On Tue, Jan 11, 2005 at 12:03:16AM -0600, [EMAIL PROTECTED] wrote:
>
> I need to know the day of the week for a schedule rotation algorithm
> i'm working on.
Others have already replied to this part.
> I've switched the datestyle format in the .conf file and used the
> set to command, but my out
On Jan 11, 2005, at 15:03, [EMAIL PROTECTED] wrote:
I need to know the day of the week for a schedule rotation algorithm
i'm working
on. Initially i was going to use the function for day of the year and
week of
the year to find the first day of the year, but it seems like it would
be easier
[EMAIL PROTECTED] writes:
> I need to know the day of the week for a schedule rotation algorithm
> i'm working on.
extract(dow ...) might help.
regards, tom lane
---(end of broadcast)---
TIP 9: the planner will ignore your d
I need to know the day of the week for a schedule rotation algorithm i'm working
on. Initially i was going to use the function for day of the year and week of
the year to find the first day of the year, but it seems like it would be easier
to use the postgres, dmy format and then parse the strin
