Hi there,
I installed postgresql 8.4 on my box and now i have troubles with the
following query regarding explicit casts.
select to_char(trunc(to_date(:the_date, '-mm-dd'), 'Month'),
'fmMonth') as month,
to_char(trunc(to_date(:the_date, '-mm-dd'), 'Month'), '')
as year,
So far,
I could write the following query
select to_char(trunc(to_date('2010-01-02', '-mm-dd'), 'Month'),
'fmMonth') as month,
to_char(trunc(to_date('2010-01-02', '-mm-dd'), 'Month'), '') as
year,
to_char(trunc(to_date('2010-01-02', '-mm-dd'), 'Month'), 'J') as
On Wednesday 05 January 2011 4:24:34 pm Iuri Sampaio wrote:
Hi there,
I installed postgresql 8.4 on my box and now i have troubles with the
following query regarding explicit casts.
select to_char(trunc(to_date(:the_date, '-mm-dd'), 'Month'),
'fmMonth') as month,
On Wednesday 05 January 2011 5:22:30 pm Iuri Sampaio wrote:
So far,
I could write the following query
select to_char(trunc(to_date('2010-01-02', '-mm-dd'), 'Month'),
'fmMonth') as month,
to_char(trunc(to_date('2010-01-02', '-mm-dd'), 'Month'), '') as
year,