Home » RDBMS Server » Networking and Gateways » Re: one solution to ORA-01861: literal does not match format string
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...
Previous Topic: TNS Adapter Error
Next Topic: connectivity for oracle database.
Goto Forum:
  


Current Time: Thu Mar 28 21:02:56 CDT 2024