Re: Date calculation
| От | Ron |
|---|---|
| Тема | Re: Date calculation |
| Дата | |
| Msg-id | 24e5ee21-0b9f-e3c8-2553-817813a04593@gmail.com обсуждение исходный текст |
| Ответ на | Re: Date calculation (Bruce Momjian <bruce@momjian.us>) |
| Ответы |
Re: Date calculation
|
| Список | pgsql-general |
On 1/31/19 2:15 PM, Bruce Momjian wrote:
> On Thu, Jan 31, 2019 at 02:11:14PM -0600, Ron wrote:
>> Hi,
>>
>> v9.6.6
>>
>> Is there a built in function to calculate, for example, next Sunday?
>>
>> For example,
>>
>> postgres=# select current_date, next_dow(current_date, 'Sunday');
>> date | date
>> ------------|------------
>> 2019-01-31 | 2019-02-03
>> (1 row)
> Uh, this worked:
>
> SELECT date_trunc('week', CURRENT_TIMESTAMP) + '6 days';
> ?column?
> ------------------------
> 2019-02-03 00:00:00-05
Perfect! All I had to do was cast that as DATE...
Thanks
--
Angular momentum makes the world go 'round.
В списке pgsql-general по дате отправления: