Setting Oracle date field

Setting Oracle date field

El Forum
Guest

02-21-2009, 04:36 AM

[eluser]pehaw[/eluser]
Hi

I'm guessing you have created your Oracle table with a datatype of DATE for column 'data_updated'?

If that is the case then you have a choice

1) Use Oracle TO_DATE function on your date variable. - ie TO_DATE(<string>, <format mask&gt Wink

eg to_date('21-jan-2009 12:30','dd-mm-YYYY hh:mi'))

2) Change the default Oracle date format to include minutes and seconds using NLS_DATE_FORMAT

3) Change your column to datatype TIMESTAMP rather than DATE.

Messages In This Thread

Setting Oracle date field - by El Forum - 02-20-2009, 01:20 PM

Setting Oracle date field - by El Forum - 02-21-2009, 04:36 AM

Setting Oracle date field - by El Forum - 02-23-2009, 10:40 AM

Setting Oracle date field - by El Forum - 04-28-2009, 07:27 PM

Setting Oracle date field - by El Forum - 12-15-2009, 11:06 AM

Setting Oracle date field - by El Forum - 08-06-2010, 01:26 PM

Setting Oracle date field - by El Forum - 08-06-2010, 02:06 PM

Setting Oracle date field - by El Forum - 08-06-2010, 02:34 PM

Setting Oracle date field - by El Forum - 08-06-2010, 03:41 PM

Setting Oracle date field - by El Forum - 08-06-2010, 07:58 PM