DB2 AS400

ID #1042

Insertion d'une date

Insertion d'une date

1) Si le type de donnée est DATE: INSERT INTO TEST.DSTESSAI (GENDATE) VALUES ('2003-10-31');

2) Si le type de donnée est TIMESTAMP(heure simple): INSERT INTO TEST.DSTESSAI (GENDATE) VALUES ('2003-10-31-19.34.03');

3) Si le type de donnée est TIMESTAMP(heure détaillée): INSERT INTO TEST.DSTESSAI (GENDATE) VALUES ('2003-10-31-19.34.03.675423');

Tags: -

Related entries:

Dernire mise jour: 2007-12-29 20:15
Auteur: Michel Preti
Rvision: 1.0

Digg it! Imprimer cet article Envoyer un ami version PDF
Propose a translation for Propose a translation for
Merci de noter cette entre:

Moyenne des notes: 0 sur 5 (0 Votes)

compltement inutile 1 2 3 4 5 indispensable

Vous ne pouvez pas commenter cet enregistrement

Comment par qQ10XoJFR7:
我和JY有一样的缩写， 每天看着工作中的签名，总会想到远方那个妹妹，多久了，竟然还留在那个冰冷的地方 Thanks for all the things you've been doing, Thanks for a warm home for her Could you email me her adderss , I will visit her some day when I go back to china All the best !
Added at: 2015-10-19 03:01

Comment par utjMUEfz:
web design brroaw Hi there! This is my 1st comment here so I just wanted to give a quick shout out and tell you I really enjoy reading through your articles. Can you suggest any other blogs/websites/forums that go over the same subjects? Thank you!
Added at: 2015-10-20 12:35