dcsimg
DB specific time, date and timestamp formatting.
1 posts in topic
Flat View  Flat View
TOPIC ACTIONS:
 

Posted By:   Monty_Zukowski
Posted On:   Thursday, October 25, 2001 01:38 PM

My database is rejecting the default timestamp format from java.sql.Timestamp. How do I make it work?


Answer: use a JDBC escape by calling

statment.setEscapeProcessing(true)
and use the following format in your sql:
			
{ts 'yyy-mm-dd hh:mm:ss.fff'}

Re: DB specific time, date and timestamp formatting.

Posted By:   AlessandroA_Garbagnati  
Posted On:   Thursday, October 25, 2001 02:21 PM

Hi,

Or, even better, use a PreparedStatement that makes everything easier...
About | Sitemap | Contact