Discussion Board for collaboration on QlikView Scripting.
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')
Go to Solution.
I am using this and it works for me:
See the below:
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)
Glad you figured it out.Close the thread accordingly.