Re: Datetime???

Article View: dk.edb.database

Article #15044

#15044

From: Martin
Date: Sun, 22 Jul 2001 19:57

21 lines
1696 bytes

On Sun, 22 Jul 2001 21:16:37 +0200, "hehe" <clark@cool.dk> wrote:

>Jeg har lavet en table med en "datetime", men n�r jeg henter r�kker fra min
>table er der ingen dato...!!
>
>Der st�r bare: "0000-00-00 00:00:00"
>
>I feltet med "datetime" er der f�lgende attributter: datetime not null.
>

Not null... betyder at der skal st� noget i feltet alts� det ikke m�
v�re tomt... og 000... er jo ikke tomt!

Du kunne ogs� s�tte default til et eller andet 2001-12-12 12:12:12
ellers s� ska du kigge p� NOW()

--
Bye for now Martin
http://wizprod.com - Billigt webdesign findes her ;o)
http://natten-i.dk - http://kew.natten-i.dk
Email: martini@mailme.dk - admin@natten-i.dk

Technical Details

Message-ID: <fvbmltcdik46rqnr2eugtkhe697r0v7fpg@4ax.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!news.tele.dk!130.227.3.83!newsfeed1.uni2.dk!sunsite.dk!not-for-mail

References: <9jf8vh$ire$1@news.cybercity.dk>

Show Full Headers

Complete Article Headers

X-Google-Language: DANISH,ASCII
X-Google-Thread: fcdf9,6fc50d6bf5621c58
X-Google-Attributes: gidfcdf9,public
X-Google-ArrivalTime: 2001-07-22 12:59:34 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!news.tele.dk!130.227.3.83!newsfeed1.uni2.dk!sunsite.dk!not-for-mail
From: Martin <martini@mailme.dk>
Newsgroups: dk.edb.database
Subject: Re: Datetime???
Date: Sun, 22 Jul 2001 21:57:51 +0200
Organization: SunSITE.dk - Supporting Opensource Software
Lines: 21
Message-ID: <fvbmltcdik46rqnr2eugtkhe697r0v7fpg@4ax.com>
References: <9jf8vh$ire$1@news.cybercity.dk>
NNTP-Posting-Host: ip201.rgnxr2.ras.tele.dk
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: sunsite.dk 995831972 24774 195.41.28.201 (22 Jul 2001 19:59:32 GMT)
X-Complaints-To: news@sunsite.dk
NNTP-Posting-Date: Sun, 22 Jul 2001 19:59:32 +0000 (UTC)
X-Newsreader: Forte Agent 1.8/32.548
X-Authenticated: <anon>@<dk>

Reply to Parent Message