hej - mam do Was pytanie o timestamp - normalnie wyswietla mi np:
2010-12-22 10:35:09.205
czy jest mozliwosc - po stronie postgresa abym wyciagala te date bez ms? czyli bym miala:
2010-12-22 10:35:09
pozdrawiam,
misty
SELECT to_char((SELECT test_date FROM test), 'YYYY-MM-DD HH24:MI:SS');
ERROR: more than one row returned BY a subquery used AS an expression
SELECT to_char((SELECT test_date FROM test LIMIT 1), 'YYYY-MM-DD HH24:MI:SS');
SELECT to_char(test_date, 'YYYY-MM-DD HH24:MI:SS') AS test_date_formatted FROM test
SELECT to_char((SELECT test_date FROM test LIMIT 1), 'YYYY-MM-DD HH24:MI:SS');
SELECT to_char((SELECT test_date FROM test), 'YYYY-MM-DD HH24:MI:SS');
SELECT to_char(test_date, 'YYYY-MM-DD HH24:MI:SS') AS test_date_formatted FROM test