Re: subtract two dates to get the number of days

Поиск
Список
Период
Сортировка
От Thomas Kellerer
Тема Re: subtract two dates to get the number of days
Дата
Msg-id i1mco5$3fk$1@dough.gmane.org
обсуждение исходный текст
Ответ на Re: subtract two dates to get the number of days  (Jean-David Beyer <jeandavid8@verizon.net>)
Список pgsql-sql
Jean-David Beyer, 14.07.2010 19:05:
> I just looked them up in my data definitions. Dates are _stored_ as type
>
> DATE NOT NULL
Very good ;) 
> Yes, if the data happen to be stored at all. But when a program
> generates the dates dynamically and wants to produce queries from them,
> it is easier to use the C++ class to generate the dates.
Yes of course.

>>> Years ago, I made a C++ data type that allowed a date datatype where I
>>> could add, subtract, and so on.
>>> I use it in programs that do not necessarily use a database,
>
>> To be honest: I expect the programming language to support those things.
>
> I would love it. For all I know, the C++ Standard Library supports it
> now, but I do not believe it did when I wrote that class.
Ah, those "historic" things. I primarily use Java and that had Date support right from the start.

> Well, €0.02 is still more than my US$0.02, I believe.

Nice one :)


Regards
Thomas





В списке pgsql-sql по дате отправления:

Предыдущее
От: Lee Hachadoorian
Дата:
Сообщение: Re: Question on COUNT performance
Следующее
От: REISS Thomas DSIC BIP
Дата:
Сообщение: Re: Question on COUNT performance