| From: | Janning Vygen <vygen(at)planwerk6(dot)de> |
|---|---|
| To: | thomas(at)pgsql(dot)com, Thomas Lockhart <lockhart(at)fourpalms(dot)org> |
| Cc: | PostgreSQL-General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: converting to german date format |
| Date: | 2001-10-01 07:30:17 |
| Message-ID: | 01100109301701.07136@janning |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Am Samstag, 29. September 2001 09:52 schrieb Thomas Lockhart:
> > i have different databases with have columns of type 'date'.
> > my application converts the date format to german date format
> > like 09-28-2001 to 28.09.2001 and back again if the user enters a
> > german date format.
> > are there any solutions to do stuff like this inside the
> > database?
>
> Of course :)
>
> thomas=# set datestyle = 'german';
> SET VARIABLE
>
> thomas=# select date 'now';
> date
> ------------
> 29.09.2001
> (1 row)
it's easier than i expected. Thanks a lot!
janning
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Emmanuel SARACCO | 2001-10-01 07:57:29 | number of views supported in 7.1 |
| Previous Message | 진희 김 | 2001-10-01 02:18:26 | Thank you for your service.... |