Articles   Members Online:
-Article/Tip Search
-News Group Search over 21 Million news group articles.
-Delphi/Pascal
-CBuilder/C++
-C#Builder/C#
-JBuilder/Java
-Kylix
Member Area
-Home
-Account Center
-Top 10 NEW!!
-Submit Article/Tip
-Forums Upgraded!!
-My Articles
-Edit Information
-Login/Logout
-Become a Member
-Why sign up!
-Newsletter
-Chat Online!
-Indexes NEW!!
Employment
-Build your resume
-Find a job
-Post a job
-Resume Search
Contacts
-Contacts
-Feedbacks
-Link to us
-Privacy/Disclaimer
Embarcadero
Visit Embarcadero
Embarcadero Community
JEDI
Links
How can I adapt DateTime values for different SQL-Server formats? Turn on/off line numbers in source code. Switch to Orginial background IDE or DSP color Comment or reply to this aritlce/tip for discussion. Bookmark this article to my favorite article(s). Print this article
Adapting DateTime values for different SQL-Server formats 14-Apr-04
Category
Database-SQL
Language
Delphi 4.x
Views
237
User Rating
No Votes
# Votes
0
Replies
0
Publisher:
DSP, Administrator
Reference URL:
DKB
			Author: Jason Madden 

How can I adapt DateTime values for different SQL-Server formats?

Answer:

If you work with different (MS-)SQL-Server, you have sometimes the problem what the 
date value is in the correct format.
1   
2   function TForm1.GetSQLDateTimeFormat(UDL: string): string;
3   begin
4     Screen.Cursor := crSQLWait;
5     if ADOConnection1.Connected then
6       ADOConnection1.Close;
7     ADOConnection1.ConnectionString := 'FILE NAME=' + UDL;
8     ADOQuery1.SQL.Clear;
9     ADOQuery1.SQL.Add('sp_helplanguage @@LANGUAGE');
10    Application.ProcessMessages;
11    try
12      try
13        ADOQuery1.Open;
14      except
15        on E: Exception do
16          MessageBox(Handle,
17            PChar('Die Abfrage konnte nicht ge÷ffnet werden:' + #13#10 + #13#10 +
18              E.message),
19            PChar('Fehler!'), 16);
20      end;
21      if (ADOQuery1.Active) and (ADOQuery1.RecordCount > 0) then
22        Result := ADOQuery1.FieldByName('dateformat').AsString;
23    finally
24      Screen.Cursor := crDefault;
25    end;
26  end;
27  
28  function DateTimeToSQLDateTimeString(Data: TDateTime; Format: string;
29    OnlyDate: Boolean = True): string;
30  var
31    y, m, d, h, mm, s, ms: Word;
32  begin
33    DecodeDate(Data, y, m, d);
34    DecodeTime(Data, h, mm, s, ms);
35    if Format = 'dmy' then
36      Result := IntToStr(d) + '-' + IntToStr(m) + '-' + IntToStr(y)
37    else if Format = 'ymd' then
38      Result := IntToStr(y) + '-' + IntToStr(m) + '-' + IntToStr(d)
39    else if Format = 'ydm' then
40      Result := IntToStr(y) + '-' + IntToStr(d) + '-' + IntToStr(m)
41    else if Format = 'myd' then
42      Result := IntToStr(m) + '-' + IntToStr(y) + '-' + IntToStr(d)
43    else if Format = 'dym' then
44      Result := IntToStr(d) + '-' + IntToStr(y) + '-' + IntToStr(m)
45    else
46      Result := IntToStr(m) + '-' + IntToStr(d) + '-' + IntToStr(y); //mdy: ; //US
47    if not OnlyDate then
48      Result := Result + ' ' + IntToStr(h) + ':' + IntToStr(mm) + ':' + IntToStr(s);
49  end;


Example:

procedure ConvertSQLDateTime;
begin
  ShowMessage(DateTimeToSQLDateTimeString(now, GetSQLLanguage('C:\DBEngl.udl')));
end;


			
Vote: How useful do you find this Article/Tip?
Bad Excellent
1 2 3 4 5 6 7 8 9 10

 

Advertisement
Share this page
Advertisement
Download from Google

Copyright © Mendozi Enterprises LLC