4 Comments

  1. VISHAL

    I WANT FORMAT 01 MAY 2015

    Reply
    • neerajyadav02

      Hi Vishal, use below statement for requested format.

      SELECT CONVERT(VARCHAR(11), GETDATE(), 113)as Date_Format

      Reply
  2. Rahul Ranjan

    I want date format in YYYY/MM or MM/YYYY
    plz reply as soon as possible.
    thanks in advance

    Reply
    • neerajyadav02

      Hi Rahul you can use below SQL statement for getting format YYYY/MM

      select convert(varchar(7),getdate(),111)

      Reply

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>