Frank Rocco
|
Posted: 05/30/2002, 11:00 AM |
|
Hello,
I recently converted from msAccess to MySQL.
The statement flddate_created = now() no longer works in ASP.
What can I do?
Thanks
Frank Rocco
|
|
|
Alexey Alexapolsky
|
Posted: 05/31/2002, 6:22 AM |
|
This piece of code helped to set current date
$flddate_entered = date("y-d-M G:i",mktime($datetime["hour"],
$datetime["minute"], $datetime["second"], $datetime["month"],
$datetime["day"], $datetime["year"])) ;
--
Alex
CodeCharge Developer
"Frank Rocco" <farocco@hotmail.com> wrote in message
news:ad5pcc$ghm$1@news.codecharge.com...
> Hello,
>
> I recently converted from msAccess to MySQL.
> The statement flddate_created = now() no longer works in ASP.
>
> What can I do?
>
> Thanks
> Frank Rocco
>
>
|
|
|
Zio Richi
|
Posted: 06/03/2002, 5:23 AM |
|
If you want current date, do NOT declare second parameter.
$flddate_entered = date("y-d-M G:i");
it's enough!
Or you could use a MySQL timestamp field: it will be automatically updated
if and only if something in your row table changes (no need to code in
codecharge).
You'll probably need a function to display the date in a suitable format on
the before show event
,
"Alexey Alexapolsky" <alexa@codecharge.com> ha scritto nel messaggio
news:ad7tea$e1o$2@news.codecharge.com...
> This piece of code helped to set current date
>
> $flddate_entered = date("y-d-M G:i",mktime($datetime["hour"],
> $datetime["minute"], $datetime["second"], $datetime["month"],
> $datetime["day"], $datetime["year"])) ;
>
>
>
> --
> Alex
> CodeCharge Developer
>
>
> "Frank Rocco" <farocco@hotmail.com> wrote in message
>news:ad5pcc$ghm$1@news.codecharge.com...
> > Hello,
> >
> > I recently converted from msAccess to MySQL.
> > The statement flddate_created = now() no longer works in ASP.
> >
> > What can I do?
> >
> > Thanks
> > Frank Rocco
> >
> >
>
>
|
|
|
|