Hi all<BR><BR>I have a great difficulty dealing with dates.<BR>Now, I have a table with a date field. (datatype :datetime)<BR>When i retreive any record from an asp page, i get the full date. Eg : 01/01/2001 2:50:00 AM<BR><BR>Now the problem is that i only require the DATE part<BR>(ie. 01/01/2001) and not the TIME.<BR><BR>Is it possible through any SQL statement or any ASP function to only retreive the DATE and not the time.<BR><BR>Plz reply ASAP.<BR><BR>Thankx !!!