aspose file tools
The moose likes JDBC and Relational Databases and the fly likes How to select time stamp data as date Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Groovy Fundamentals video training course this week in the Groovy forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "How to select time stamp data as date" Watch "How to select time stamp data as date" New topic
Author

How to select time stamp data as date

M Wilson
Ranch Hand

Joined: May 23, 2010
Posts: 32
I would like to know how in my sql to select the date part of a time stamp date?
For example:
select REF_NO, STAT_CD, DATE_TS
FROM TABLE

The result of this returns DATE_TS = 2011-01-24 08:45:19.977
How can my sql return just the 2011-01-24 part of it?

Thank you very much.
Tom Reilly
Rancher

Joined: Jun 01, 2010
Posts: 618
Try Googling mysql Date(). Please respond if you need more information.
 
 
subject: How to select time stamp data as date