SREE time format CSV

From PTAGISWiki

Running this query in SREE 9.1:

select obs_date from obs_data where obs_date between '6/1/2004' and '6/5/2004' and obs_site = 'BO2'

Results in a CSV with dates like this:

2004-06-01 10:01:27.0

However, running this query:

select char(obs_date) from obs_data where obs_date between '6/1/2004' and '6/5/2004' and obs_site = 'BO2'

Returns this date:

2004-06-01 10:01:27