Insert into postgresql timestamp issue #259

New Issue

lunny · 2015-06-16T04:15:30Z

ltang952 commented

2015-06-16 04:15:30 +00:00

(Migrated from github.com)

when insert into postgresql table, time.Time type miss values after second.
for example,
values is 2015-06-16 12:05:15.7338519 +0800 CST
after insert into table the values is 2015-06-16 12:05:15

seems function FormatTime in engine.go is not good

when insert into postgresql table, time.Time type miss values after second. for example, values is 2015-06-16 12:05:15.7338519 +0800 CST after insert into table the values is 2015-06-16 12:05:15 seems function FormatTime in engine.go is not good

YueHonghui commented

2015-07-20 15:16:43 +00:00

(Migrated from github.com)

As a good habit for myself, I always use unix timestamp(second or microsecond or nanosecond) instead regardless of what kinds of SQL server. Maybe you can take it into your account.

lunny modified the milestone from (deleted) to (deleted)

2020-03-03 12:59:15 +00:00

lunny removed this from the (deleted) milestone 2023-07-26 01:23:43 +00:00

Sign in to join this conversation.

No Milestone

No Assignees

1 Participants

Notifications

Due Date

The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.

No due date set.

Dependencies

No dependencies set.

Reference: xorm/xorm#259