Results 1 to 2 of 2

Thread: Date conversion

  1. #1
    mehool Guest

    Date conversion


    Hello All,

    I need help in converting a date. What i'm looking for is date in format of mm/yyyy.

    Thanks in advance.

  2. #2
    MAK Guest

    Date conversion (reply)


    select substring(convert(varchar(12),getdate(),103),4,7)



    ------------
    mehool at 3/19/01 9:53:31 AM


    Hello All,

    I need help in converting a date. What i'm looking for is date in format of mm/yyyy.

    Thanks in advance.

Posting Permissions

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