Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2003
    Posts
    6

    Unanswered: Extract time from timestamp without time zone

    Hi all,

    I just want to extract time from a timestamp without time zone attribute on PostgreSQL 7.3.4-RH.
    Function date() [select date(now())] is working perfectly,
    but function time() [select time(now())] returns ERROR: parser: parse error at or near "now" at character 13.
    What is the tricky function to do that?
    Thanks,
    Jonathan.

  2. #2
    Join Date
    Mar 2003
    Posts
    6
    Ok, I found it: select "time"(now());

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •