A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
JDBC and Relational Databases
How to select time stamp data as date
Joined: May 23, 2010
Jan 24, 2011 10:48:18
I would like to know how in my sql to select the date part of a time stamp date?
select REF_NO, STAT_CD, DATE_TS
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.
Joined: Jun 01, 2010
Jan 24, 2011 17:20:04
. Please respond if you need more information.
Have you checked out
subject: How to select time stamp data as date
Passing Date in Callable Statement
getting last row
problem while inserting date field in oracle data base
how to convert gregoriancalendar obj to sqldate?
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015