Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2002
    Location
    UK
    Posts
    67

    Unanswered: Displaying Date in SQL View

    Hi,

    I am a preety newbie to SQL and was wondering how to get the date from the SQL to show up as Format(Date, "dd/mm/yyyy").

    TIA.

    Rohit

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: Displaying Date in SQL View

    It depends on your DBMS. For Oracle, it is TO_CHAR( date, 'DD/MM/YYYY' )

  3. #3
    Join Date
    Jan 2002
    Location
    UK
    Posts
    67
    Thanks a lot sir,

    My problem was to get this value somehow.

    Thanks a lot for your help.

    rohit

  4. #4
    Join Date
    Jul 2002
    Location
    India
    Posts
    13

    Smile

    if it is SQL Server you can use Convert function to convert the date into any format for ex: Select Convert(Varchar(10), GetDate() ,101)
    will give you the date in mm/dd/yyyy format.
    it depends upon the No you provide in the convert function, 101 stands for "mm/dd/yyyy" format

    Balaji

    Balaji

Posting Permissions

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