Home....
Developer Network >> Other Programming >> Database

queryby date

sql2000; is this best safest way to query by date?. what if output is null?.
select ride_number as ridenum from
clubA where Driver_name = 'Gary' and
clubA.Date_Time = '4/12/1999 8:28:01 PM'
[222 byte] By [ikcha] at [2007-11-20 10:44:29]
«« can english vb application run on Japanese OS
»» Is it possible to add button control to tree view?
# 1 Re: queryby date
The fastest queries are well defined by WHERE clauses. Also having a fast server with an optimized database helps.

SELECT field FROM db.table WHERE field = 'value' AND/OR ...
PeejAvery at 2007-11-9 13:45:27 >
# 2 Re: queryby date
sql2000; is this best safest way to query by date?. what if output is null?.
select ride_number as ridenum from
clubA where Driver_name = 'Gary' and
clubA.Date_Time = '4/12/1999 8:28:01 PM'

I prefer to use 'yyyyMMdd' format with dates for portability with different date formats, it's always acceptable.
off course, I wish you use parameterized queries :)
hspc at 2007-11-9 13:46:38 >
Other Programming
Database

Other Programming

All Classified

Other Programming New Topic

Other Programming Hot Topic