Toad World® Forums

Quick Export & Export to File - Toad for SQL Server Beta

Toad for SQL Server Beta


When I use the ‘Quick Export’ to any of the ‘Excel Instance’ options DATETIME type fields export and appear in the mm/dd/yyyy hh:mm:ss format

The ‘Quick Export, File, Excel File’ appears as the dd/mm/yyyy hh:mm:ss format - which is preferred as a UK user

I would like to see the ‘Quick Export’ facility export DATETIME fields as dd/mm/yyyy hh:mm:ss universally regardless of the method of export used.

MONEY Fields

When exporting fields of a MONEY type, the format is showing with a dollar ($) symbol as opposed to the UK Pound (£) symbol which is set as the currency on my PC

I would like to see the export of this field type to be as UK Pound (£)

I can confirm that the Region for my PC is English (United Kingdom) with a date format of dd/MM/yyyy and currency symbol of £

Is this something that is configurable from within Toad? Or could Toad be configured to use the Regional settings of PC?

Thanks for your posting, I created an enhancement(QAT-6076) for it.

Andy Chang