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

Thread: Convert date to number

  1. #1
    Join Date
    Aug 2007
    Posts
    62

    Convert date to number

    Hi,

    I need to append the date to a unique number for each insert according to the date at which the data is being insert.

    Is there a way to convert sysdate to say 05112007? The nearest i can get is '05/11/2007' by using
    select to_date(sysdate,'dd-mm-yyy') from dual

    In any case, is there such a thing called a date sequence?

    Thanks!

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    select to_char(sysdate,'DDMMYYYY') from dual

Posting Permissions

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


Click Here to Expand Forum to Full Width