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
Joined: Aug 27, 2002
Aug 25, 2004 15:55:00
I created a
object in following way and insurted it in my_table
Date d = new Date(System.System.currentTimeMillis());
When I use SQL+ to check, I found that no hour, minute, and second info:
SQL> select TO_CHAR(my_dt, 'mm-dd-yyyy hh24:mi:ss') as My_dt from my_table;
Could anyone tell me why? I'm using Oracle. Thanks!
Author and ninkuma
Joined: Jan 10, 2002
Aug 25, 2004 17:17:00
is just a date (unlike
). If you want to store a timestamp, use
Asking smart questions
Books by Bear
I agree. Here's the link:
subject: Date format
24 Hour Format In HQL - 00:00:00 returned as 24:00:00 using HQL
convert datetime from EST to PST
Calendar() / Date() bug ???
Date comparision in SQL from timestamp
date format problem
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014