| Re: one solution to ORA-01861: literal does not match format string [message #66793] |
Tue, 14 January 2003 14:31 |
A.C.
Messages: 1
Registered: January 2003
|
Junior Member |
|
|
insert into your_table_name
(varchar_field,
qty_field,
date_field_in_oracle)
values
('varchar_variable',
qty_variable,
to_date('#variable_time_date#', 'yyyy/mm/dd hh:mi:ss'),
where '#variable_time_date#' is a date variable (in my case it was a cold fusion variable)
Of course you can change the time date format of the to_date Oracle function, this is just an example...
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
