date menace
Posted: Mon May 24, 2004 1:52 am
Hi members,
I hav got a problem as below.
I am storing current timestamp in a field called dDate using time() function. This will take into consideration the current date and the time.
I want to run a sql query to select a record, which has been inserted on a specific date ( say 20/5/2004). Here the date filter is specified in dd/mm/yyyy format. As no time value is specified. The records i want to filter may have been inserted at any time on say 20/5/2004. If i want to list all the records entered on this perticular date how should i write the query. [mysql_man][/mysql_man]
I hav got a problem as below.
I am storing current timestamp in a field called dDate using time() function. This will take into consideration the current date and the time.
I want to run a sql query to select a record, which has been inserted on a specific date ( say 20/5/2004). Here the date filter is specified in dd/mm/yyyy format. As no time value is specified. The records i want to filter may have been inserted at any time on say 20/5/2004. If i want to list all the records entered on this perticular date how should i write the query. [mysql_man][/mysql_man]