Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2004
    Posts
    5

    Unanswered: How to convert dates to numeric numbers

    Question: How would you determine the numeric number from two different dates ?

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool


    What do you mean by "numeric number"?

    TO_CHAR(SYSDATE,'YYYYMMDD') -- Year-Month-Day?
    TO_CHAR(SYSDATE,'YYYYDDD') -- Year-Day?
    TO_CHAR(SYSDATE,'J') -- Julian date?

    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  3. #3
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    LKBrwn_DBA, this is the SQL forum, not the Oracle forum

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  4. #4
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool


    There are equivalent functions in T-SQL and other SQL languages to produce the same results. The idea is to emphasize what he means by "numeric number".

    PS: Is a number is allways "numeric"?.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

Posting Permissions

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