Alex Thurgood a écrit :
En exécutant l'instruction SQL avec CURRENT_DATE, le statut renvoyé est "Wrong data type".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 Pourtant la solution doit être proche ! J.M ![]() |
- Re: [users-fr] [Base] comment saisir la date du jour ? Secrétariat
- Re: [users-fr] [Base] comment saisir la date du jour ... Alex Thurgood
- Re: [users-fr] [Base] comment saisir la date du j... Secrétariat
- Re: [users-fr] [Base] comment saisir la date ... Alex Thurgood
- Re: [users-fr] [Base] comment saisir la d... Secrétariat
- Re: [users-fr] [Base] comment saisir... Alex Thurgood
- Re: [users-fr] [Base] comment sa... Secrétariat
- [users-fr] Re: [Base] commen... Maurice Starck
- Re: [users-fr] Re: [Base] co... Secrétariat
- Re: [users-fr] [Base] commen... Francois Gatto
- Re: [users-fr] [Base] commen... Secrétariat