Solved: UCCX5, how to SQL insert the timestamp

cjrchoi11 · ‎06-13-2009

Hi,

I want to insert the current time into database no luck with the below syntax. name field is okay but I guess there is something different way to handle the timestamp.

!

set get_timestamp=T[now]

db write(sql insert (name,timestamp) values ($name,$get_timestamp))

!

database field definition,

-name=char(10)

-timestamp=timestamp(8)

!

Advise please how to achieve,

Thanks in advance,

villarrealed · ‎06-14-2009

In your db Write step use this as your sql statment:

insert into TABLENAME (name, timestamp) values($name, getdate())

View solution in original post

villarrealed · ‎06-14-2009

In your db Write step use this as your sql statment:

insert into TABLENAME (name, timestamp) values($name, getdate())

cjrchoi11 · ‎06-14-2009

Thanks Ed, it works perfect after change the database column attribute to 'datetime' with your syntax.