Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Posts
    4

    Unanswered: Date for Matisse SQL

    What's the syntax for constant of date type with Matisse?
    I tried 'yyyy-mm-dd', but Matisse does not like it,
    UPDATE ... SET a.date = '2004-01-01'

    Thank you in advance,

  2. #2
    Join Date
    Jan 2004
    Posts
    4
    UPDATE ... SET a.date = DATE '2004-01-01'
    should work.

Posting Permissions

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