HomeFlySpeed SQL QueryHow to format Date columns from SQL Server

How to format Date columns from SQL Server


I am using SQL 2000, and querying tables from that, which contain datetime columns.

the SQL server is set to Australian date settings (DD/MM/YYYY) but no matter how i try, Flyspeed always returns the date in the US format (MM/DD/YYYY).

is there any way to do the conversion, or set a default format, as i need the output to be in the Australian format for my reports.

Thanks,
Simon
Simon Morgan | email
June 26 2011, 09:13 PM
Dear Simon.

It is not possible to do in the current version. We will add this possibility in the next minor version.
Sergey Smagin | email
1 week, 4 days since original post
This topic is closed