From: | Lukasz Brodziak <lukasz(dot)brodziak(at)gmail(dot)com> |
---|---|
To: | Helgi Örn <sacredeagle(at)gmail(dot)com> |
Cc: | PostgreSQL - newbie <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Alternative to AS? |
Date: | 2010-10-06 09:09:43 |
Message-ID: | AANLkTi=Bx7wqAFuDr6UnOeHRVCO-CEVaJ+HvZ46Oz2gE@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hi,
From You've written You want to convert time formatting. If that is
the case thisarticle may be of help:
http://www.postgresql.org/docs/8.0/static/datatype-datetime.html
2010/10/6 Helgi Örn <sacredeagle(at)gmail(dot)com>:
> Hi! I am moving a database project from MySQL to PostgreSQL I was a
> newbie there and now I am a newbie here :)
>
> I have this form mysql:
> SELECT tid_in, TIME_FORMAT(tid_in, '%H.%i')AS format FROM timmar;
>
> Which I have gotten postgre to accept thus far:
> SELECT pack_tidin TIME_FORMAT, pack_tidin '%H.%i', AS format FROM timmar;
>
> it stops at AS which doesn't seem to exist is postgre, what is
> postgres alternative to AS?
>
>
> Thank's in advance,
> Helgi Örn
>
> --
> Sent via pgsql-novice mailing list (pgsql-novice(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-novice
>
--
Łukasz Brodziak
II MU Bioinformatyka
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Kellerer | 2010-10-06 09:26:52 | Re: Alternative to AS? |
Previous Message | Helgi Örn | 2010-10-06 08:58:03 | Alternative to AS? |