Skip to content
«
»
 

SQL Cast Date

Posted by 
on  June 2 2009

You are currently browsing comments. If you would like to return to the full story, you can read the full entry here: “SQL Cast Date”.

Filed under SQL
Comment (RSS)  |  Permalink

7 Comments

  1. suhas says:
    December 23, 2011 at 12:43 am

    how to insert current date in table. in sql server 2005

    Reply to this comment
  2. mostafa says:
    September 25, 2011 at 1:22 am

    very nice
    Tank’s

    Reply to this comment
  3. saboor says:
    June 8, 2011 at 7:35 am

    I have a problem
    I have a datetime and i need the date to specific format

    so I just casted datetime to time
    SELECT CAST (GETDATE() AS DATE)

    and for formatting i use convert
    SELECT CONVERT(DATE,CAST (GETDATE() AS DATE),105)

    but, the result of both is same,

    convert is not working formating

    Reply to this comment
  4. Kosta Masalov says:
    June 7, 2011 at 9:19 am

    Exactly what I was looking for, thanks!

    Reply to this comment
  5. INal says:
    January 25, 2011 at 10:17 pm

    Thanks you. This is most helpful.

    Reply to this comment
  6. Dom says:
    October 10, 2010 at 5:09 pm

    Thanks, perfect exactly what I need to Know

    Reply to this comment
  7. WILLIAM says:
    July 16, 2009 at 9:52 pm

    thanks for the effort

    Reply to this comment

post a comment OR Post Your Question on our ASK! Community!

«
»