I have created A table in sql server having following field
I want to display all the record of this table where created date will be system date and created time will before the current system time but on the current sytem date
Plz help me In generating this query
might be what you want but as Kev says, it may well revolve around your data types.
I would also add its not a good practice to use column names with spaces, if you want to make them more readable then use an underscore, such as "`created_date`".
answered Nov 13, 2010 at 03:14 PM