Skip site navigation (1) Skip section navigation (2)

Alternative to AS?

From: Helgi Örn <sacredeagle(at)gmail(dot)com>
To: PostgreSQL - newbie <pgsql-novice(at)postgresql(dot)org>
Subject: Alternative to AS?
Date: 2010-10-06 08:58:03
Message-ID: AANLkTinSCQ9ux33BUeJwkqsA19mV-pPwhpdQNJYdy7U2@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
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

Responses

pgsql-novice by date

Next:From: Lukasz BrodziakDate: 2010-10-06 09:09:43
Subject: Re: Alternative to AS?
Previous:From: Mladen GogalaDate: 2010-10-05 19:50:07
Subject: Re: WHEN NO_DATA_FOUND THEN....

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group