A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
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.
It is sorta covered in the
JavaRanch Style Guide
subject: How to select time stamp data as date
how to convert gregoriancalendar obj to sqldate?
problem while inserting date field in oracle data base
Passing Date in Callable Statement
getting last row
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2013