Subject | selecting a date |
---|---|
Author | lee@leeway-be.com |
Post date | 2001-07-04T17:45:23Z |
what is the correct way to select a date from a table.
I got a TDateTime with a date and a time
In a table I got several dates with several times
I want to make a selection for a specific date
How do I have to do this ?
This does not work :
Curr_Date: TDateTime;
Q_Pim.SQL.Add('select * from PIM where DATE_START >= ' + DateTimeToStr
(Curr_Date));
I got a TDateTime with a date and a time
In a table I got several dates with several times
I want to make a selection for a specific date
How do I have to do this ?
This does not work :
Curr_Date: TDateTime;
Q_Pim.SQL.Add('select * from PIM where DATE_START >= ' + DateTimeToStr
(Curr_Date));