Re: [users-fr] [Base] comment saisir la date du jour ?

Fri, 27 Apr 2007 00:42:23 -0700

Alex Thurgood a écrit : 
Le jeudi 26 avril 2007 11:MM, Secrétariat a écrit :

La doc HSQLDB :

Components of a CREATE TABLE command

columnDefinition

    columnname Datatype [(columnSize[,precision])]
        [{DEFAULT <defaultValue> |
        GENERATED BY DEFAULT AS IDENTITY
        (START WITH <n>[, INCREMENT BY <m>])}] |
        [[NOT] NULL] [IDENTITY] [PRIMARY KEY]

    Default values that are allowed are constant values or certain SQL 
datetime functions.

    Allowed Default Values in Column Definitions

        *

          For character column, a single-quoted string or NULL. The only SQL 
function that can be used is CURRENT_USER.
        *

          For datetime columns, a single-quoted DATE, TIME or TIMESTAMP value 
or NULL. Or a datetime SQL function such as CURRENT_DATE, CURRENT_TIME, 
CURRENT_TIMESTAMP, TODAY, NOW. Each function is allowed for a certain 
datetime type.


Alex
En exécutant l'instruction SQL avec CURRENT_DATE, le statut renvoyé est "Wrong data type".
Pourtant la solution doit être proche !
J.M


Répondre à