How to I convert this code from Oracle to SQL Server?

• kawi6rr

  SSC-Addicted

  Points: 403

  More actions

  August 1, 2017 at 5:10 pm

  #339146

  I haven't been able to successfully update this code.

  Oracle
  REPLACE(TO_CHAR(PRAC.DATE_OF_BIRTH,'MM-DD-YYYY'),'-','/') AS DOB,

  SQL Server
  REPLACE(CAST(PRAC.DATE_OF_BIRTH AS DATE ['MM-DD-YYYY']),'-','/') AS DOB,

  Thanks in advance for any assistance.

• Sue_H

  SSC Guru

  Points: 90860

  More actions

  August 1, 2017 at 5:29 pm

  #1953688

  kawi6rr - Tuesday, August 1, 2017 5:10 PM

  I haven't been able to successfully update this code.

  Oracle
  REPLACE(TO_CHAR(PRAC.DATE_OF_BIRTH,'MM-DD-YYYY'),'-','/') AS DOB,

  SQL Server
  REPLACE(CAST(PRAC.DATE_OF_BIRTH AS DATE ['MM-DD-YYYY']),'-','/') AS DOB,

  Thanks in advance for any assistance.

  It depends on what the data type is for DATE_OF_BIRTH.
  Generally you can use something like:
  SELECT REPLACE(CONVERT (varchar(10), GETDATE(), 110), '-', '/') AS DOB
  which would return today's date as 08/01/2017

  Sue

• John Mitchell-245523

  SSC Guru

  Points: 148809

  More actions

  August 2, 2017 at 2:57 am

  #1953717

  Yes, or return dates as dates, and if you need to make it all look pretty, do that in the presentation layer.

  John

• Luis Cazares

  SSC Guru

  Points: 183706

  More actions

  August 2, 2017 at 6:19 am

  #1953755

  Or you could remove the REPLACE altogether with a different format code.
  SELECT CONVERT (char(10), GETDATE(), 101) AS DOB

  But I agree with leaving the formatting in the presentation layer and keep the dates as dates for as long as possible.

  Luis C.
  General Disclaimer:
  Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

  How to post data/code on a forum to get the best help: Option 1 / Option 2