How to insert dates (need to do some testing) into tables?
In literal SQL text, I use the format 'YYYY-MM-DD HH24:MI:SS', as in:
insert into tran values ('2008-02-01 08:09:10')
Also when I am populating this field from a form or populating from a
Java variable to store it in the Database, how can I control the format
e.g. YYYY-MM-DD or YYYY/DD/MM
In Java code, you will find that the classes Calendar and DateFormat
are the places to look for manipulating java.util.Date and java.sql.Timestamp
values.
thanks,
bryan
