POSTGRES SQL: Make query output date string rather than the object

veryangryman · 14-04-2017 08:42AM #1

08:52:48.406 DEBUG Executing : Select visit_date from patient_visits where patient_id = '50' AND site_id = '216' ORDER by patient_id DESC LIMIT 1 08:52:48.416 TRACE Return: [(datetime.date(2017, 2, 17),)]

When i run this direct in workbench i get

2017-02-17

How can i make the query return the string instead of the datetime.date bit above. Some formatting needed?

Colonel Panic · 14-04-2017 09:58AM

https://www.postgresql.org/docs/9.6/static/functions-formatting.html

You can use to_char to format the date when converting it to a string.

veryangryman · 18-04-2017 09:01AM

No joy...something obvious im doing wrong?

ProgrammingError: function to_char(date) does not exist
LINE 1: Select to_char(visit_date) from patient_visits where patient...

Woden · 18-04-2017 09:11AM

Do you need to give it a format? e.g. to_char(start_date, 'YYYY-MM-DD')

http://www.java2s.com/Code/PostgreSQL/Date-Timezone/tocharstartdateYYYYMMDD.htm

veryangryman · 24-04-2017 12:37PM

Woden wrote: »

Do you need to give it a format? e.g. to_char(start_date, 'YYYY-MM-DD')

http://www.java2s.com/Code/PostgreSQL/Date-Timezone/tocharstartdateYYYYMMDD.htm

Bingo thanks

POSTGRES SQL: Make query output date string rather than the object

Comments