chunky1
asked on
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 ?
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 ?
Listening
ASKER
Edited text of question.
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('The Date').AsD ateTime := TDateTimeVar
queryname.Open;
meikl
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('The
queryname.Open;
meikl
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Why didn't I think of that ?