Originally posted by Jigar Naik:
Hi
I'm using mysql as my backend. and when i say rs.getString("create_date"); in my sql its giving error.
the create_date field is of data type TIME STAMP which has the format
0000-00-00 00:00:00
is there anyway out i can get the date in the format 0000-00-00 or i can store the while timestamp value in the format 0000-00-00 00:00:00
It would be usefull to tell us exactly what error you get.
Timestamps can be retrieved by using (pseudocode):
You can format this Date as you please, using the
SimpleDateFormat.
Regards, Jan