inserting timestamp values into Snowflake table

Question

we are inserting values to a table through a procedure , one values we are inserting is current_timestamp. throwing below while inserting timestamp values. too many arguments for function [TO_TIMESTAMP(CURRENT_TIMESTAMP(), 'DD-MM-YYYY HH:MI:SS')] expected 1, got 2\n Stack Trace:\nundefined\n

below is the syntax:

var create_vol1=snowflake.execute({sqlText: "INSERT INTO CDW_DB.LOAD_timestamp VALUES (TO_TIMESTAMP(Current_Timestamp,'DD-MM-YYYY HH:MI:SS'))"});

please correct me if i am wrong here.

Thanks

Simon D · Accepted Answer · 2021-04-06 13:48:28Z

1

The current_timestamp function already returns a timestamp so you don't need to do anything to it. Just insert it like this:

INSERT INTO CDW_DB.LOAD_timestamp VALUES (Current_Timestamp)

answered Apr 6, 2021 at 13:48

Simon D

6,3752 gold badges25 silver badges41 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

BalajiAWS Over a year ago

Thanks Simon, i have used it but it is loading extra -000 at the end of value, i need to load in this format 'dd-mm-yyyy hh-mi-ss', that is why i am using to_timestamp.

Simon D Over a year ago

What is the data type of the column you're inserting into? There is a difference between a timestamp and a string representation of a timestamp. Timestamp data types don't have a format.

BalajiAWS Over a year ago

data type is Timestamp

BalajiAWS Over a year ago

how would we convert to a specified format if it is having data type as Timestamp?

Simon D Over a year ago

Have a read of this documentation about the different types of timestamps. The first step would be to understand which one you're using for that column. You may have to look up the timestamp_type_mapping if it's really just shown as timestamp docs.snowflake.com/en/sql-reference/…

|

Collectives™ on Stack Overflow

inserting timestamp values into Snowflake table

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related