cancel
Showing results for 
Search instead for 
Did you mean: 

Sap hana studio date field how to set default value

joseih
Explorer
0 Kudos

Hi guys, i have this field in Hana that is a date type, i want this field to return a default value of the current time, how do i do that

View Entire Topic
joseih
Explorer
0 Kudos

I was trying to alter the table with this code


ALTER TABLE "SBO_JC_TST"."ORDR"

ADD CONSTRAINT "CurrentDateComp"

DEFAULT CURRENT_DATE FOR "U_Competencia"

but it keeps giving me a syntax error