Hi all,
Successful solved.
I'm just using to_timestamp function.
Thanks
On Wed, 21 Jul 2004 10:45:27 -0400, Rod Taylor <[EMAIL PROTECTED]> wrote:
> On Tue, 2004-07-20 at 23:53, azah azah wrote:
> > Thanks Chris and Rod.
> >
> > I think I have a problem becau
Thanks all, :)
It working now, i'm using code as below:
to_char(t1.created::date,'DD/MM/')
but other problem come out, error as below:
ERROR: relation "plugins" does not exist
what that's mean?? table plugins already exists..
On Thu, 22 Jul 2004 10:
|
> Modifiers
> -+--+-
> acode| text|
> not null
> createdate | timestamp with time zone | default
> now()
>
> extremedb=> SELECT to_char(cast (clientinfo.createdate
>
Hi,
I want convert from mysql to postresql, previously
in mysql the code as below:
SELECT t2.id, t2.name, date_format(t1.created,\'%W %M %e, %Y - %r\')
In postresql no date_format function, we need to use to_char function
but it still work because still need to put ::date such as
SELECT to_char
wrote:
> On Tue, 2004-07-20 at 20:55, azah azah wrote:
> > Hi,
> > I want convert from mysql to postresql,
> > in mysql, query to database using the code as below:
> >
> > date_format(submittime, "%W %M %e, %Y - %r")
>
> to_char(submittime, 'fo
Hi,
I want convert from mysql to postresql,
in mysql, query to database using the code as below:
date_format(submittime, "%W %M %e, %Y - %r")
what the format query in postresql? Anyone who can help me?
Thanks
-Azah-
---(end of broadcast)---
TIP 2
