On Thu, Aug 08/01/13, 2013 at 09:24:11AM +0000, Christian(dot)Strobl(at)dlr(dot)de wrote:
>
> hi all,
>
> i want to create an timestamp with to_timestamp() and i get always an output like this
>
> [(datetime.datetime(2013, 7, 29, 9, 2, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=0, name=None)),)]
>
Are you looking to get back a string? Cast to TEXT first:
SELECT CAST(to_timestamp ('130729.0902', 'YYMMDD.HH24MI') AS TEXT);
-Ryan