Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I am using this and it works for me:
format(created_date,'dd-MMM-yyyy')
Hi,
See the below:
Thanks
Hi Sinan,
The end result should be in the format 'DD-MON-YYYY'
Note: The datatype of getdate is : Datetime2
use 106. From sinan expression use like
Convert(nchar, Getdate(), 106)
I am using this and it works for me:
format(created_date,'dd-MMM-yyyy')
Glad you figured it out.Close the thread accordingly.