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

Re: Alternative to AS?

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: (view raw or whole thread)
Lists: pgsql-novice

From You've written You want to convert time formatting. If that is
the case thisarticle may be of help:

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:

Łukasz Brodziak
II MU Bioinformatyka

In response to


pgsql-novice by date

Next:From: Thomas KellererDate: 2010-10-06 09:26:52
Subject: Re: Alternative to AS?
Previous:From: Helgi ÖrnDate: 2010-10-06 08:58:03
Subject: Alternative to AS?

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