SQL Query help

[aarohipatel]

Hi ,

I am trying to write the following Oracle database query in SQL Server database

to_date(to_char(GETDATE(), 'DD-MON-YYYY'), 'DD-MON-YYYY')

Please suggest.

Thank you

[sinanozdemir]

Hi,

See the below:

Thanks

[aarohipatel]

Hi Sinan,

The end result should be in the format 'DD-MON-YYYY'

Note: The datatype of getdate is : Datetime2

[vishsaggi]

use 106. From sinan expression use like

Convert(nchar, Getdate(), 106)

[aarohipatel · Accepted solution]

I am using this and it works for me:

format(created_date,'dd-MMM-yyyy')

[vishsaggi]

Glad you figured it out.Close the thread accordingly.