i got following error in SQL 2000
'TO_CHAR' is not a recognized function name.
also the sysdate function is not working in SQL 2000

so how can i get records entered in last 24 hours???