Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2002
    Posts
    25

    Exclamation Unanswered: Formatting Dates

    Hi all,

    Soryy for the question because of its simplicity but i'm newbie.

    I have a date column in the following format:

    2002-04-01 15:16:32.187

    I want to query and show this column in the format:

    dd/mm/yyyy

    How can I do it in a simple query?. I don't want to use cursors or user defined functions.

    Thanks in advance.

    God Bless

  2. #2
    Join Date
    Jul 2002
    Location
    Village, MD
    Posts
    621
    select convert(varchar(10),getdate(),103)

Posting Permissions

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