You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@hive.apache.org by Shyam Sarkar <sh...@yahoo.com> on 2009/02/11 23:48:46 UTC

Datetime type in SQL standard

Following is the BNF for datetime type in SQL 2003::

<datetime type>    ::= 
         DATE 
     |     TIME [ <left paren> <time precision> <right paren> ] [ <with or without time zone> ]
     |     TIMESTAMP [ <left paren> <timestamp precision> <right paren> ] [ <with or without time zone> ]

Please let me know if we implement the standard completely or not.

Thanks,
shyam_sarkar@yahoo.com