Teradata TimeStamp to Oracle Timestamp(9) -- 12 hour format
Moderators: chulett, rschirm, roy
Teradata TimeStamp to Oracle Timestamp(9) -- 12 hour format
Having trouble converting - '2007-08-13 02:59:13.730829 PM' to an Oracle 12 Hour Timestamp Have tried to_date('yyyy-mm-dd hh:mi:ss.ff6am' (among others) can't find any documentation
-
- Participant
- Posts: 612
- Joined: Thu May 03, 2007 4:59 am
- Location: Melbourne
Try editing Teradata timestamp to oracle timestamp format using [] function.
Joshy George
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>