Hi,
I have to read from SQL Server database a string which has a format 'MM/DD/YYYY HH:MI:SS PM', and save them as Date datatype in Oracle. How do I do that? I got errors when I tried the following:
1. SQL Server as Varchar - Oracle as Timestamp and used TO_DATE(:138, 'MM/DD/YYYY HH:MI:SS PM') during insertion
2. SQL Server as Timestamp - Oracle as Timestamp and used TO_DATE(:138, 'MM/DD/YYYY HH:MI:SS PM') during insertion
Thanks..
SQL server varchar to Oracle date format
Moderators: chulett, rschirm, roy
One error is:
Abnormal termination of stage VRV_ORDERS_DRS..Transformer_24
detected
Or sometimes:
ORDERS_STG..Transformer_24: ORA-01830: date format picture ends before converting entire input string
-- probably because the SQL Server format is 'YYYY-MM-DD 00:00:00.000'
and the Oracle tries to convert using TO_DATE(:138, 'YYYY-MM-DD HH24:MI:SS')
Abnormal termination of stage VRV_ORDERS_DRS..Transformer_24
detected
Or sometimes:
ORDERS_STG..Transformer_24: ORA-01830: date format picture ends before converting entire input string
-- probably because the SQL Server format is 'YYYY-MM-DD 00:00:00.000'
and the Oracle tries to convert using TO_DATE(:138, 'YYYY-MM-DD HH24:MI:SS')
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: