[Mifos-developer] date in database

[Shekko]

the database manages a date, which is independent of the date of the
server (which used to run tasks)?. in which table and field? please

------------------------------------------------------------------------------
This SF.Net email is sponsored by the Verizon Developer Community
Take advantage of Verizon's best-in-class app development support
A streamlined, 14 day to market process makes app distribution fast and easy
Join now and get one step closer to millions of Verizon customers
http://p.sf.net/sfu/verizon-dev2dev

[Ryan Whitney]

Hello Shekko,

We are not exactly sure what you are asking, can you please add more detail
to your question?

Thanks,
Ryan

--
Ryan Whitney
Mifos Technical Program Manager
rwhi...@grameenfoundation.org
Mifos - Technology that Empowers Microfinance (www.mifos.org)
Our mission is to enable the poor, especially the poorest, to create a world
without poverty.
<http://grameenfoundation.org/take-action/ingenuity-fund-challenge/>
P please consider the environment before printing this e-mail.

[Shekko]

i mean, any field in some table in the database which is
"calculated" (something like but not exactly: actual_date =
actual_date +1) and of course is independet of the server system date
(but in the most of case are equals).

i was working with a bank system, a long time ago and the database
has something like my example.

my client asking for something like that, in mifos, we are in the
localization process.

i saw in the table scheduled_tasks, the fields starttime an endtime,
but any of them say me what date is today.

I am looking for a field that can make a query and tell me what day it
is without having to resort to the time server system

On 30 dic, 16:00, Ryan Whitney <rwhit...@grameenfoundation.org> wrote:
> Hello Shekko,
>
> We are not exactly sure what you are asking, can you please add more detail
> to your question?
>
> Thanks,
> Ryan
>

> On 12/27/09 20:48, "Shekko" <krilin.checo.ser...@gmail.com> wrote:
>
> > the database manages a date, which is independent of the date of the
> > server (which used to run tasks)?. in which table and field? please
>
> > ------------------------------------------------------------------------------
> > This SF.Net email is sponsored by the Verizon Developer Community
> > Take advantage of Verizon's best-in-class app development support
> > A streamlined, 14 day to market process makes app distribution fast and easy
> > Join now and get one step closer to millions of Verizon customers
> >http://p.sf.net/sfu/verizon-dev2dev
>
> --
> Ryan Whitney  
> Mifos Technical Program Manager

> rwhit...@grameenfoundation.org

> Mifos - Technology that Empowers Microfinance (www.mifos.org)
> Our mission is to enable the poor, especially the poorest, to create a world
> without poverty.  
> <http://grameenfoundation.org/take-action/ingenuity-fund-challenge/>
> P please consider the environment before printing this e-mail.
>
> ------------------------------------------------------------------------------
> This SF.Net email is sponsored by the Verizon Developer Community
> Take advantage of Verizon's best-in-class app development support
> A streamlined, 14 day to market process makes app distribution fast and easy
> Join now and get one step closer to millions of Verizon customershttp://p.sf.net/sfu/verizon-dev2dev

------------------------------------------------------------------------------

[Adam Feuer]

On Wed, Dec 30, 2009 at 6:15 PM, Shekko <krilin.ch...@gmail.com> wrote:
> i mean, any field in some table in the database which is
> "calculated" (something like but not exactly: actual_date =
> actual_date +1) and of course is independet of the server system date
> (but in the most of case are equals).

[...]

> I am looking for a field that can make a query and tell me what day it
> is without having to resort to the time server system

Shekko,

Can you use the MySQL 'now()' function?

select now();

http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html

This will give you the current timestamp (date and time) that the
database thinks is now.

Ideally, your application server and database server will be
synchronizing with the network time servers, and should be on the same
time. We don't want to write the time to the database every second or
millisecond because that just wastes CPU cycles.

Does this help?

-adam
--
Adam Feuer <adamf at pobox dot com>