开发者

is it possible to explicity insert values in timestamp column of DB2

开发者 https://www.devze.com 2023-01-16 18:58 出处:网络
is it possible to explicity insert values in timestamp column of DB2? For example i have a date time value \'2\\11\\2005 4:59:36 PM\'. How to convert it to timestamp value in DB2?

is it possible to explicity insert values in timestamp column of DB2? For example i have a date time value '2\11\2005 4:59:36 PM'. How to convert it to timestamp value in DB2?

开发者_如何学运维Thanks in advance


Another way to specify insert into timestamp field:

insert into mytable (timestamp_field, ...) values ('2018-07-25-14.56.11.000000', ...)


INSERT INTO TimeStampTable(TIMESTAMPFIELD, ...) 
VALUES ((TIMESTAMP(CAST('04.02.2005' AS VARCHAR(10)),'13:14:53')),...)
0

精彩评论

暂无评论...
验证码 换一张
取 消