A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Date Conversion in SQL
Joined: Jan 05, 2007
Jun 14, 2007 05:50:00
I need to enter both date and time in a table in Oracle in a column which is of type 'Date'. In the 'update table' query, I use the following for conversion:
But I am getting this error:
ERROR at line 1:
ORA-01830: date format picture ends before converting entire input
I have googled for this query and found that it is perfectly alright.
The dateString will be a date viz. '2007-06-14 09:31:24.762'.
Any body has any inputs on this?
Thanks in Advance.
RAGHU<br /> <br />"When the going gets tough, the tough get going"
Joined: Dec 20, 2006
Jun 14, 2007 14:40:00
Oracle specs expect an uppercase mask:
and you have to drop the .762. It does not match your SS mask.
[ June 14, 2007: Message edited by: Jan Cumps ]
OCUP UML fundamental and ITIL foundation
I agree. Here's the link:
subject: Date Conversion in SQL
connot resolve symbol-variable calculate
Question about DateFormat class
Has my compiler lost it?
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2013