PDA

View Full Version : TO_DATE format



tom123
Nov 20th, 2006, 03: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
Nov 21st, 2006, 11: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
Nov 21st, 2006, 06: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