Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Posts
    5

    Unanswered: Create date Function using SQL

    Do anyone know any functions in SQL to create a new date using numeric numbers eg.

    day=1, month=2 , year=2003

    final = 01/02/2003


    please help thanks

  2. #2
    Join Date
    May 2003
    Location
    France
    Posts
    112

    Re: Create date Function using SQL

    to_date(lpad(day,2,'0')||'/'||lpad(month,2,'0')||'/'||year,'dd/mm/yyyy')

    Originally posted by Twinki
    Do anyone know any functions in SQL to create a new date using numeric numbers eg.

    day=1, month=2 , year=2003

    final = 01/02/2003


    please help thanks

Posting Permissions

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