Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2006
    Posts
    19

    Unanswered: how to view date dimenstion

    plese help

    I want to view date dimentions like DD/MM/YY, doen't want to include time.

    Thank you

  2. #2
    Join Date
    Jan 2006
    Location
    USA
    Posts
    115
    SELECT Convert(varchar(10), GetDate(), 105) as date

    For more option explore convert() function...
    Rajesh Patel

    Everybody says - mistake is the first step of success, but it's not true. The correction of the mistake is the first step of success.

Posting Permissions

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