Follow

SQL-0003: Proper Use of "current_timestamp()" Function

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.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.