DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: String to Date conversion

  1. 07-21-2008, 11:27 AM #1
    airnewhouse
    airnewhouse is offline Junior Member
    Join Date
    Jul 2008
    Posts
    5

    String to Date conversion

    I have a 3rd party OCR software that can only export a date in a YYYY0DOY format. The 0 just separates the 4 digit year (YYYY) from the number of days into the year (DOY). So, for example it puts today's date which is July 21, 2008 as 20080203. Its the 203rd day of 2008. Is there an easy way to convert the 203 into July 21 so that I can combine that with the year to export into a valid date column in Oracle 9i?
    Reply With Quote Reply With Quote
  2. 07-21-2008, 12:00 PM #2
    airnewhouse
    airnewhouse is offline Junior Member
    Join Date
    Jul 2008
    Posts
    5
    Nevermind, I see that I can just use YYYYDDD date format...duh...
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width