Re: [SQL] Datetime field

1. If you define it as TIMESTAMP instead of DATETIME you have the format
   as you desire.

2. If you set DateStyle TO 'ISO', you may have the same result. Take a
look:


prova=> create table tbl ("Time Stamp"  timestamp, "Date Time"
datetime);
CREATE
prova=> insert into tbl values (current_timestamp, 'now');
INSERT 82754 1

prova=> \x
turned on expanded table representation

prova=> set datestyle to 'POSTGRES';
SET VARIABLE
prova=> select * from tbl;
Field     | Value
-- RECORD 0 --
Time Stamp| 1998-09-17 17:19:48+02
Date Time | Thu 17 Sep 17:19:48 1998 CEST
(1 row)

prova=> set datestyle to 'ISO';
SET VARIABLE
prova=> select * from tbl;
Field     | Value
-- RECORD 0 --
Time Stamp| 1998-09-17 17:19:48+02
Date Time | 1998-09-17 17:19:48+02
(1 row)


I hope this help you
      Jose'



Henrik Denseje Pedersen wrote:
>
> Hi all...
>
> In a database i have created a datetime field.. its works fine, but is
> there someway i can get the result back in "normal" date format
> instead of this "Wed Aug 19 00:00:00 1998 MET DST".
>
> I need to use it in my program, so i need it in the normal datetime format:
> wich is : 08-19-98 00:00:00
>
> By the way, im programming in Perl, so if anyone know a funktion to
> convert it back, that could be helpfull too
>
> Yours Sincerely
>
> Henrik Pedersen
> --