TO_DATE format

tom123

11-20-2006, 02:45 PM

Hi Guys,

Having trouble converting and adding a date to table, the date string is of the format 31-12-2006 16:21, and in the INSERT im trying

'TO_DATE($details{'start_date'},'DD-MM-YYYY HH24:MI'),
'TO_DATE($details{'end_date'}','DD-MM-YYYY HH24:MI'),

Any ideas?

Thanks in advance.

tom123

11-21-2006, 10:22 AM

TO_DATE('$details{'start_date'}','DD-MM-YYYY HH24:MI'),
TO_DATE('$details{'end_date'}','DD-MM-YYYY HH24:MI'),

Was just missplaced single quotes in perl!!!

guelphdad

11-21-2006, 05:27 PM

tom, if you are posting in the general database forum, please specify the database you are using. there are differences in syntax (as well as things like what values can be held in a date string) between databases.

Thanks