Re: Fixing faulty dates - select on day part of a date field - Mailing list pgsql-sql

From Patrik Kudo
Subject Re: Fixing faulty dates - select on day part of a date field
Date
Msg-id 20011129131110.D86979-100000@tb303.partitur.se
Whole thread Raw
In response to Fixing faulty dates - select on day part of a date field  (Gary Stainburn <gary.stainburn@ringways.co.uk>)
List pgsql-sql
Hi

1. You could use date_part(). Try these things
select date_part('day', now());select date_part('month', now());select date_part('year', now());

2. Yeah, should be able to do it in one update

Regards,
Patrik Kudo

On Thu, 29 Nov 2001, Gary Stainburn wrote:

> Hi all,
>
> I've got a problem with dates on one of my tables. I've been inserting dates
> in the format 'dd/mm/ccyy' which for the days 13-31 for each month worked
> fine.
>
> The problem I have is that for the days 01-12 for each month, the date was
> interpretted as 'mm/dd/ccyy'.  Now I know about it I need to fix it.
>
> Two questions.
>
> 1) how can I select on part of a date?  I need to select all records where
> the day is not > 12.
> 2) can I do this in a single update, i.e. can I do something around
>
> update calls set xdate =  ???? where ??????;
>
> --
> Gary Stainburn
>
> This email does not contain private or confidential material as it
> may be snooped on by interested government parties for unknown
> and undisclosed purposes - Regulation of Investigatory Powers Act, 2000
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>



pgsql-sql by date:

Previous
From: Gary Stainburn
Date:
Subject: Fixing faulty dates - select on day part of a date field
Next
From: Markus Bertheau
Date:
Subject: Re: Fixing faulty dates - select on day part of a date field