db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bernt M. Johnsen" <Bernt.John...@Sun.COM>
Subject Re: Need Urgent Help: Timestamp
Date Wed, 11 Feb 2009 07:55:22 GMT
>>>>>>>>>>>> Gerald Wheeler wrote (2009-02-09 10:35:09):
> All,
>   I have a java application created w/netbeans 6.5 
>  I am trying to input a date time into a Derby timestamp field 
> using default pattern the insert statements work correctly and display
> Jan 2, 1991 12:00:00
> 
> How does one enter data into Derby timestamp field from an application
> using the default timestamp pattern??
> 2009-01-01 13:00;01 does not work
> 
> Jan 2, 1991 12:00:00 does not work
> 
> What is the correct time stamp format to enter??
> Thanks
> J


YYYY-MM-DD HH:mm:ss

E.g.

2009-01-01 13:00:01





-- 
Bernt Marius Johnsen, Staff Engineer
Database Technology Group, Sun Microsystems, Trondheim, Norway

Mime
View raw message