Syntax to convert Datetime to Date
I am very new to Veritica and i am stuck at this issue.
I have a column called 'Transactiodatetime' in my Table. I am creating a View on top of this Table but in the View i need a RequestDate column.
Below is the Syntax i am using but i am getting an Error
select to_char(transactiondatetime,'DD-MM-YYYY') as RequestDate
Error - [Error Code: 2005, SQL State: 42601] [Vertica][VJDBC](2005) ERROR: Multiple decimal points.
Can someone please help me getting the correct syntax.
Thanks in advance !!