Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2012
    Location
    India,Mumbai
    Posts
    34

    Unanswered: Date Conversion Function

    Hi All,

    I need your help to convert the current date time format 'mm/dd/yyyy hh:mm:ss' into 'mmddyyyyhhmmss' format.

  2. #2
    Join Date
    Jan 2012
    Location
    Lisbon
    Posts
    115
    Provided Answers: 1
    Hello,

    Try this:

    select str_replace ( str_replace ( convert ( varchar, getdate(),101) + convert(varchar, getdate(),108), '/',null),':',null)

    Hope it helps
    Last edited by Catarrunas; 05-23-12 at 07:12.

  3. #3
    Join Date
    Feb 2012
    Location
    India,Mumbai
    Posts
    34
    Thanks Catarrunas !!!!!!

Posting Permissions

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