Hello team,
I want to create the GetDate() in synapse sqlpool for one of the column in the table .
I am using this table in data factory pipeline dynamically. So i can't create select statement. So i need to display current date and time in the select statement for column3.So I need to mention in create table statement.
Please advise.
![80351-image.png][1]
Create table Table1
(
column1 [nvarchar](20) NULL,
column2 [int] NULL,
CAST(GETDATE() AS datetime) AS column3
)
WITH ( DISTRIBUTION = ROUND_ROBIN, HEAP )
[1]: /answers/storage/attachments/80351-image.png