Retrieve Date
[email protected] Fri, 14 Feb 2003 17:34:08 +0800
| Newsgroups | gmane.comp.db.oracle.devel |
|---|---|
| Message-ID | <LYRIS-1796914-874064-2003.02.14-09.35.37--gcdod-oracle#[email protected]> |
Hi,
I got the following error when executing the below sql statement.
select * from d_schedule where SCHEDULE_DATE= to_date('2003-02-14
15:44:22', 'yyyy-mm-dd hh:mm:ss')
*
ERROR at line 1:
ORA-01810: format code appears twice
Pls help. Thanks.
Best Regards,
- nicole -
---
Change your mail options at http://p2p.wrox.com/manager.asp or
to unsubscribe send a blank email to [email protected].