topic Re: SQL Query help in QlikView

SQL Query help

aarohipatel — Tue, 11 Jul 2017 20:43:33 GMT

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 — Tue, 11 Jul 2017 20:51:08 GMT

Hi,

See the below:

Thanks

aarohipatel — Tue, 11 Jul 2017 21:16:39 GMT

Hi Sinan,

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

Note: The datatype of getdate is : Datetime2

vishsaggi — Tue, 11 Jul 2017 21:22:07 GMT

use 106. From sinan expression use like

Convert(nchar, Getdate(), 106)

aarohipatel — Wed, 12 Jul 2017 16:08:29 GMT

I am using this and it works for me:

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

vishsaggi — Wed, 12 Jul 2017 16:13:01 GMT

Glad you figured it out.Close the thread accordingly.