How to insert CURRENT TIMESTAMP into sql - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

How to insert CURRENT TIMESTAMP into sql

How to insert CURRENT TIMESTAMP into sql# Database - 数据库

a*s2002-08-06 07:08

1 楼

i followed example but it doesn't accept, always say there is error parse near
TIMESTAMP, pls. help me and tell me what the problem is.
I did:
INSERT INTO items VALUES(......,CURRENT TIMESTAMP,...);
The attribute has been set to be TIMESTAMP when i created this table.
Why I can't insert CURRENT TIMESTAMP?

s*i2002-08-06 07:08

2 楼

not sure which database you are using, but
try CURRENT_TIMESTAMP

【在 a**********s 的大作中提到】

: i followed example but it doesn't accept, always say there is error parse near
: TIMESTAMP, pls. help me and tell me what the problem is.
: I did:
: INSERT INTO items VALUES(......,CURRENT TIMESTAMP,...);
: The attribute has been set to be TIMESTAMP when i created this table.
: Why I can't insert CURRENT TIMESTAMP?

n*m2002-08-06 07:08

3 楼

It should be CURRENT TIMESTAMP if you use DB2. I just tried it on my Machine.
and works.

【在 s**********i 的大作中提到】

: not sure which database you are using, but
: try CURRENT_TIMESTAMP

a*s2002-08-06 07:08

4 楼

It's PostgreSQL... it doesn't work...
Machine.
parse near

s*i2002-08-06 07:08

5 楼

postgresql manual says:
The following functions are available to obtain the current date and/or time:
CURRENT_DATE
CURRENT_TIME
CURRENT_TIMESTAMP
CURRENT_TIME ( precision )
CURRENT_TIMESTAMP ( precision )
The function now() is the traditional PostgreSQL equivalent to
CURRENT_TIMESTAMP.

【在 a**********s 的大作中提到】

: It's PostgreSQL... it doesn't work...
: Machine.
: parse near