Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How get just date part of datetime column in SQL
- Thread starter gazolba
- Start date
- Thread starter
- #3
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
SQL Consulting
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
SQL Consulting
- Status
Similar threads
- Locked
- Question
- Question
