Hi Ryan, Thanks a lot for your reply.
How should I `insert into' a timestamp field in postgres? When I apply a sql-timestamp to query-exec, I got exceptions: `` query-exec: cannot convert given value to SQL type given: (sql-timestamp 2013 5 5 21 56 22 480000000 #f) type: int2 expected: int16? dialect: PostgreSQL '' -------------- Daniel ☵☯☲ 2013/5/5 Ryan Culpepper <[email protected]>: > On 05/04/2013 01:22 PM, Kejia柯嘉 wrote: >> >> Hi, >> >> How should I construct a postgresql timestamp in terms of current time? >> >> Thanks. > > > On the Racket side: > > (require db db/util/datetime (prefix-in srfi: srfi/19)) > (srfi-date->sql-timestamp-tz (srfi:current-date)) > > On the server side: > > (define c (postgresql-connect ___)) > (query-value c "select now()") > > Ryan > ____________________ Racket Users list: http://lists.racket-lang.org/users
