Overview:
At times, there may be a need to update a column of timestamp value with the current date/time. This can be achieved via the use of the current_timestamp() function in SQL. The following illustrates the proper use of the current-timestamp() function in Kinetica:
Error:
EXECUTING...
SQL: INSERT INTO task_progress (id, assignee_name, date_added, completion) values (001, 'Bob Jones', (select current_timestamp()), 'c')
=============================================================
Connection successful
Catalog [KINETICA]
Deployment Time: 0.241 s
[Kinetica][GPUdb] (1042) GPUdb Error in GetRecordsByColumn: Schema must have at least three fields.
EXECUTION ERROR OCCURRED
Action:
The following syntax should be used to achieve this function:
INSERT INTO task_progress (id, assignee_name, date_added, completion)
SELECT 001, 'Bob Jones', CURRENT_TIMESTAMP(), 'c'
Additional Information:
- Affected Version(s): 6.1, 6.2
Should you have any questions or concerns, please visit our Official Documentation and Support Page.
0 Comments