Skip to Content
0
Former Member
Oct 01, 2014 at 07:22 AM

Date output format in SAP HANA

2196 Views

Hi Experts,

I am executing following statement -

SELECT NOW () "now" FROM DUMMY;

And the output format I get is -

01-Oct-2014 07:19:46.657.

As I know the default format in HANA is YYYY-MM-DD and hence the output should appear like 2014-10-01.

What governs the date output format and how to control it? Any global settings to be done in HANA Studio?

Regards,

Shiwesh