limitation.
Both can handle unix timestamps which are beyond this limitation.
Still, there is a limitation for timestamps when using databases which is
commonly 1900/1914 - 2038
Greetings
Thomas Weidner, I18N Team Leader, Zend Framework
http://www.thomasweidner.com
----- Original Message -----
From: "Hector Virgen" <djvirgen@gmail.com>
To: "Thomas VEQUAUD" <thomas.vequaud@gmail.com>
Cc: <fw-db@lists.zend.com>
Sent: Tuesday, April 07, 2009 4:50 PM
Subject: Re: [fw-db] Storing a Zend_Date in a Zend_Db_Table
My only concern with unix timestamps is their limited range. Do databases
support negative unix timestamps, for dates before 1970?
-Hector
On Tue, Apr 7, 2009 at 7:03 AM, Thomas VEQUAUD
<thomas.vequaud@gmail.com>wrote:
> You can define a macro MYSQL_DATEPART within the bootstrap file where
> the date part is YYYY-MM-DD HH:MM:SS and you call your Zend_Date
> object with it : $date->get(MYSQL_DATEPART)
> But, like Paul said, it's really easier and better to use timestamp
> instead of a formated date.
>
> Now, it's up to you...
>
>
> On Mon, Apr 6, 2009 at 8:26 PM, Hector Virgen <djvirgen@gmail.com> wrote:
> > Would it be a step in the right direction to include format constants
> > for
> > various db types?
> > For example, $date->toString(Zend_Date::MYSQL_DATETIME) could produce
> > '2009-04-06 11:24:37'
> > -Hector
> >
> >
> > On Mon, Apr 6, 2009 at 11:20 AM, Thomas Weidner <thomas.weidner@gmx.at>
> > wrote:
> >>
> >> The problem with this approach is that it is not database agnostic.
> >> The expression to set depends on the used DBMS.
> >>
> >> Greetings
> >> Thomas Weidner, I18N Team Leader, Zend Framework
> >> http://www.thomasweidner.com
> >>
> >> ----- Original Message ----- From: "Thomas VEQUAUD"
> >> <thomas.vequaud@gmail.com>
> >> To: "Thomas Weidner" <thomas.weidner@gmx.at>
> >> Cc: <fw-db@lists.zend.com>; <darylhandley@gmail.com>
> >> Sent: Monday, April 06, 2009 4:49 PM
> >> Subject: Re: [fw-db] Storing a Zend_Date in a Zend_Db_Table
> >>
> >>
> >> Or just :
> >> $paymentData = array(
> >> 'DATE' => new Zend_Db_Expr('SYSDATE'),
> >> 'USERID' => $userId,
> >> 'AMOUNT' => $amount
> >> );
> >>
> >> On Thu, Apr 2, 2009 at 7:09 AM, Thomas Weidner <thomas.weidner@gmx.at>
> >> wrote:
> >>>
> >>> There are two ways:
> >>>
> >>> Eighter use getTimestamp to store the date as unix timestamp. Note
> >>> that
> >>> databases as also Zend_Date supports negative timestamps and
> >>> timestamps
> >>> beyond 32bit integer.
> >>>
> >>> Or use toString() and get the format you want to have manually...
> >>> (toString('dd.MM.yyyy HH:mm:ss') for example)
> >>>
> >>> There are issues to add dbagnostic date format to Zend_Db, but they
> >>> are
> >>> actually not solved and have not much users which voted for them.
> >>>
> >>> Greetings
> >>> Thomas Weidner, I18N Team Leader, Zend Framework
> >>> http://www.thomasweidner.com
> >>>
> >>> ----- Original Message ----- From: "Daryl Handley"
> >>> <darylhandley@gmail.com>
> >>> To: <fw-db@lists.zend.com>
> >>> Sent: Thursday, April 02, 2009 1:37 AM
> >>> Subject: [fw-db] Storing a Zend_Date in a Zend_Db_Table
> >>>
> >>>
> >>>> I'm trying to store a date in a db table (using Oracle) and it fails
> >>>> telling
> >>>> me.
> >>>>
> >>>> ORA-01858: a non-numeric character was found where a numeric was
> >>>> expected
> >>>>
> >>>> My code looks something like this
> >>>>
> >>>> $paymentData = array(
> >>>> 'DATE' => Zend_Date::now(),
> >>>> 'USERID' => $userId,
> >>>> 'AMOUNT' => $amount
> >>>> );
> >>>> $paymentDbTable = new PaymentDbTable();
> >>>> $paymentDbTable->insert($paymentData);
> >>>>
> >>>> I've also tried using Zend_Date::now()->getIso() and it doesn't like
> >>>> that
> >>>> much either (ORA-01861: literal does not match format string).
> >>>>
> >>>> I have a couple of workarounds but I don't really like either of them
> >>>> because they kind of tie it to Oracle (format into a string literal
> that
> >>>> Oracle likes or use a Zend_Db_Expr('SYSDATE'). In Java this was
> >>>> pretty
> >>>> simple and you just pass the date and the adapter layer figures out
> what
> >>>> to
> >>>> do. I've got to think there must be an easy db agnostic way to do it
> in
> >>>> Zend
> >>>> as well.
> >>>>
> >>>> Thanks
> >>>> Daryl
> >>>>
> >>>
> >>>
> >>
> >>
> >>
> >> --
> >> Thomas VEQUAUD http://thomas.vequaud.free.fr/
> >> Expert EPITECH en Ingénierie Informatique
> >> Tél : +33(0)6.50.39.28.10 Fax: +33(0)9.58.46.10.07
> >
> >
>
>
>
> --
> Thomas VEQUAUD http://thomas.vequaud.free.fr/
> Expert EPITECH en Ingénierie Informatique
> Tél : +33(0)6.50.39.28.10 Fax: +33(0)9.58.46.10.07
>
没有评论:
发表评论