SQL*Loader meridian format problem
From: Kirk K. Johnson <kk_johnson_at_pnl.gov>
Date: Wed, 15 Jul 1998 19:44:35 -0700
Message-ID: <35AD6913.8ABC7C6E_at_pnl.gov>
I am trying to load a Sybase datafile with the datetime string "Mon DD YYYY HH:MI:SS:000AM" I am using the following format string to read in the line from loader:
Date: Wed, 15 Jul 1998 19:44:35 -0700
Message-ID: <35AD6913.8ABC7C6E_at_pnl.gov>
I am trying to load a Sybase datafile with the datetime string "Mon DD YYYY HH:MI:SS:000AM" I am using the following format string to read in the line from loader:
"To_Date (substr(:LAST_LOGIN_DT,1,20)||substr(:LAST_LOGIN_DT,25,2),'Mon DD YYYY HH:MI:SS AM')" It works fine as long as the meridian is AM, if it is PM then it's off to the bad row file. How do I specify either AM or PM in my to_date function? Received on Thu Jul 16 1998 - 04:44:35 CEST