on 08-17-2016 4:05 AM
Hi Experts,
Just need some assistance with HANA SQL script.(SELECT statement)
Is there a function to convert current_date to a 'dd/mm/yyyy' format?
thanks
Tony
Even if the format is not listed in the current documentation, you can use a statement like
SELECT TO_NVARCHAR(CURRENT_DATE, 'DD/MM/YYYY') as "MyConvertedCurrentDate" from dummy;
If really a format is not supported you could also use functions DAYOFMONTH, MONTH and YEAR to extract the single components of a date value and concatenate the string by yourself (with some formatting).
Regards,
Florian
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
and how do you change the number to the name of the month in SQL HANA?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.