Mailing List Archive


Back to the month index Back to the list index
Brian Goldfarb (briang@delta.net)
Tue, 29 Apr 1997 15:05:00 -0700 

Message-Id: <199704292205.PAA22182@mail2.deltanet.com>
From: "Brian Goldfarb" <briang@delta.net>
Subject: Re: [mSQL] Insert into date field (lite)
Date: Tue, 29 Apr 1997 15:05:00 -0700

I'm having the exact same problem. Did you every figure out how to insert
a date and how to work with date fields in b6? Any help would be
appreciated.

Thanks,
Brian

---------------------------------------------------------------- ----
From: Joerg Over <jover@arco.met.fu-berlin.de>
To: msql-list@Bunyip.Com
Date: Saturday, April 26, 1997 2:08 PM
Subject: [mSQL] Insert into date field (lite)

>That seemed so easy...
>I'm jost doing my very first steps with with msql 2B6 and it seems that
>I
>just cant get a date value into a date field, because I don't know the
>format.
>I found out that it has to be included by ', but thats all.
>I tried insert with the following:
>'3/4/1997',
>'1997/3/4',
>'03/04/1997',
>(0,0,0,4,3,1997),
>$datum = time2unixtime(0,0,0,3,4,1997); and inserting $datum,
>'03.04.1997'
>'1997.03.04'
>I tried a (date) cast operator...
>I tried to insert a NULL value and dump the table... (Got a NULL, of
>course)
>even TO_DATE() and so on, because I usually work with ORACLE and thought
>I could try...
>You can see, I got desperate.
>I've been browsing the manual, the faq,the bookmark database example...
>I even tried to find it in the code, but ... give me a break...
>Can't be that tough... just one tiny date... I'm beginning to cry.
>Please, drop me a line with an insert statement and a date value in the
>lite syntax.
>THIS SOUNDS SILLY, I know. Thanks a lot. Joerg
>
>

BrianGoldfarb
briang@delta.net
DeltaNet Web Services (http://www.delta.net/)

--------------------------------------------------------------------------
To remove yourself from the Mini SQL mailing list send a message containing
"unsubscribe" to "unsubscribe" to msql-list-request@bunyip.com. Send a message containing
"info msql-list" to majordomo@bunyip.com for info on monthly archives of
the list. For more help, mail owner-msql-list@bunyip.com NOT the msql-list!