File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Win a copy of
The Mikado Method
this week in the
Agile and other Processes
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.
I agree. Here's the link:
subject: How to select time stamp data as date
how to convert gregoriancalendar obj to sqldate?
Passing Date in Callable Statement
problem while inserting date field in oracle data base
getting last row
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2013