RE: [PEAR] [MDB] default timestamp field to current time support?
| From: | Lukas Smith | Date: | Thu, 21 Aug 2003 07:15:55 +0000 |
| Subject: | RE: [PEAR] [MDB] default timestamp field to current time support? | ||
| References: | 1 | Groups: | php.pear.general |
| Request: | Send a blank email to pear-general+get-7322@lists.php.net to get a copy of this message | ||
> From: Alan Richmond [mailto:alan@aardwolfweb.com]
> Sent: Thursday, August 21, 2003 9:07 AM
> To: Thierry B.; pear-general@lists.php.net
> Subject: RE: [PEAR] [MDB] default timestamp field to current time
support?
>
> ] is it planned to add an emulation for default current time
> ] in timestamp MDB
> ] fields?
>
> Hi Thierry,
>
> MDB has a separate class for creating/converting dates,
> MDB_Date::mdbNow() is what you're looking for.
Glad you found the list.
I haven't had time to answer you just yet Thierry.
In your mail to me you were asking about support for default time in MDB
Schema. No this is not available and not planned either. If I were to do
this I would ponder a way to abstract all sorts of SQL functions.
However the schema manager currently blindly accepts whatever you pass
it as a default value. So if all the RDBMS that you want to support use
the same function call to get NOW() then you can do it like that.
Regards,
Lukas