default timestamp to current_timestamp

Follow

George Tang

• September 24, 2024 17:33
• Edited

How do you create a table with a column that defaults to the current time?

My impression is that the syntax is something like this:

create table queries(

    query text encoding none,

    time_of_query TIMESTAMP DEFAULT CURRENT_TIMESTAMP,

    embedding text encoding dict(8)

);

 

I get the error "Invalid TIMESTAMP string (CURRENT_TIMESTAMP)"

I've been trying variations of "time_of_query TIMESTAMP DEFAULT CURRENT_TIMESTAMP" to no avail.

 

Please point me in the right direction. Thanks.

0

• 

  George Tang

  • September 24, 2024 17:36

  I found someone else logged this issue:
  
  https://github.com/heavyai/heavydb/issues/665

  I'll look to solve it then.

  0

  Comment actions Permalink

Please sign in to leave a comment.