..::rDk::.. wrote:
im strugling with my dataset..got a small pgsql db with a timestamp column in format YYYY:MM:DD HH:MM:SS for each record
Use to_char to_char(tscol, 'dy') -> mon to_char(tscol, 'Day') -> Monday to_char(tscol, 'D') -> 2 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general