How get just date part of datetime column in SQL

[gazolba]

How get just date part of datetime column in SQL?

 

[Golom]

Several Ways

Format (DateField, "yyyy-mm-dd")

cDate ( Int ( DateField ) )

DateSerial ( Year(DateField), Month(DateField), Day(DateField) )

 

[gazolba]

Are any standard SQL as opposed to Jet-specific ??

 

[dhookom]

I don't think there is any generic sql method for this. In Access, I would use:
DateValue([DateTimeField])


Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[r937]

the sql standard allows for three types of temporal data: DATE, TIME, and TIMESTAMP

they look and behave exactly like thier names indicate -- DATE stores dates (only), TIME stores times (only), and TIMESTAMP stores a datetime down to a nanosecond

to convert from one to the other, use the CAST function

not very useful when you're talking about Access, but hey, you did ask...

rudy

http://r937.com/

SQL Consulting