Format of date query in SQL statements.

My database explorer displays date formats as follows : DD/MM/YYYY

But when I use an SQL statement I have to input it as : MM/DD/YYYY

How can I change the layout that SQL will accept my query ?
LVL 1
chunky1Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
florisbConnect With a Mentor Commented:
Option: tell your users to use a specific date format by the control panel....;-(

Or use FormatDateTime from Sysutils. Do check the help.

Part of code building SQL statement:
    result := myField+'>='+'#'+FormatDateTime('d/m/yyyy', dtpVanaf.Date)+'#'+' AND '+myField+'<='+'#'+FormatDateTime('d/m/yyyy', tmpDate)+'#';

Good luck,
Floris.
0
 
AswCommented:
Listening
0
 
chunky1Author Commented:
Edited text of question.
0
 
kretzschmarCommented:
hi chunky1,

the best and format-independent method is to use a parameter, like

the sql-statement sample
select * from ATable where ADateField = :TheDate

now u can use following code:

queryname.parambyname('TheDate').AsDateTime := TDateTimeVar
queryname.Open;

meikl
0
 
chunky1Author Commented:
Why didn't I think of that ?
0
All Courses

From novice to tech pro — start learning today.