Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003
    Posts
    11

    Angry Unanswered: Update timestamp record to null

    Hi.

    Well, I have to update a timestamp record from a table.

    If I do

    UPDATE table SET timestamp_field = '' WHERE some_id = some_number ;

    I get the message

    ERROR: Bad timestamp external representation ''.

    What can I do to update a timestamp record to null?

    Thanks !
    Pablo Velasquez Rivas
    Computer Science Engineer - ITCR

  2. #2
    Join Date
    Jan 2004
    Posts
    26

    Re: Update timestamp record to null

    Use this:

    UPDATE table
    SET timestamp_field = null
    WHERE some_id = some_number ;


    Originally posted by pvelasquez
    Hi.

    Well, I have to update a timestamp record from a table.

    If I do

    UPDATE table SET timestamp_field = '' WHERE some_id = some_number ;

    I get the message

    ERROR: Bad timestamp external representation ''.

    What can I do to update a timestamp record to null?

    Thanks !

Posting Permissions

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