Forum Stats

  • 3,874,202 Users
  • 2,266,682 Discussions
  • 7,911,768 Comments

Discussions

DATE help

449465
449465 Member Posts: 111
edited Apr 27, 2010 12:22PM in SQL & PL/SQL
Dear all, i have the date comming in txt file as 2010-03-20 16:21:09.340


I am trying to insert that date into my oracle table through sql loader control file where the datatype is date. i wanted in the table only date. in the control file i have the coulmn name 'trans_dt'. how can i mention in the control file the above mentioned( 2010-03-20 16:21:09.340) trypical date format.


With regards
Phani

Edited by: phani_Marella on Apr 27, 2010 8:40 AM
Tagged:

Answers

This discussion has been closed.