[SA 7.2.338 Pro] Postgresql - improper output datatype

[SA 7.2.338 Pro] Postgresql - improper output datatype

Please try

	Code:
	SELECT date_trunc('second', TIMESTAMP '2015-05-31 23:59:59.83588');

Result should be TIMESTAMP WITHOUT TIME ZONE.
SA returns DATE

	Quote:
	Result should be TIMESTAMP WITHOUT TIME ZONE.

That's exactly what I get TIMESTAMP WITHOUT TIME ZONE. Please see the mouse-over hint on my screenshot below (click it to enlarge). The display of the value looks like a date because the time portion is 00:00:00 and that part is simply omitted. This is by design in the data grid. If the time is all zeroes, it's committed because in many cases developers use date-time based data types for storing date-only values.

But the result of this date_trunc is not zeroes on hour/min/sec positions.
SELECT date_trunc('second', TIMESTAMP '2015-05-31 23:59:59.83588');
---------------
'2015-05-31 23:59:59'

I found another test case:
SELECT '2015-05-31 22:3:59'::TIMESTAMP
SA shows '2015-05-31' as result.
The same with SELECT NOW();
Looks like general bug. However it shows timestamp correctly if selected from table.

BTW I don't like apps which are trying to be smarter than they are actually. The design you described is not good thing IMO and might be misleading.
At least, It should be configurable (if it isn't already).

	Quote:
	The same with SELECT NOW();

That must be a bug related to incorrect display of PostgreSQL date-time values. I tested the same with MSSQL and MySQL databases and it returned correct date-time value including the time portion. I'm going to submit a ticket for incorrect display of certain types of PostgreSQL data types

Just in case, here bug tracking # for this issue SA0026521