Hi,

I have a SQL database table with a datetime field in dd/mm/yyyy
format.

I have a web page that allows users to search this database.

How do you search a datetime field?

i.e., I want users to be able to enter a date into a text
field that will search the database.

I know it's not as simple as saying SELECT * FROM TABLE WHERE
dateField = theTextFieldVariable.

Any help much appreciated

S

what's problem with "SELECT * FROM Table WHERE dateField = 'dd/mm/yyyy'?

You can also search date range using "BETWEEN' and "AND" predicate.
For e.g. ..WHERE dateField BETWEEN 'your_start_date' AND 'your_end_date'

Hi SoC,

Whatever the date format being used in the frontend, convert it to a format that is similar to that od the date in database. Else use a standard format throughout the application. When dd/mm/yyyy is the format used in DB, you can use the same from the frontend too. Otherwise, follow the "yyyy-mm-dd" format.

Post here if you face any problem in doing so.

Cheers!

_________________________
- Vijay G
Strive for Perfection