Specifies an optional override for the default Datetime format when retrieving data with SuiteQL.

Data Type

string

Default Value

""

Remarks

Use this property to override the default Datetime format when querying NetSuite using SuiteQL. This affects how datetime values are formatted in query results, but does not change how they are stored in NetSuite.

For example, if NetSuite's default format is DD/MM/YYYY HH:MM:SS, but you prefer YYYY-MM-DD HH:MM:SS, set: SuiteQLDatetimeFormat=YYYY-MM-DD HH:MM:SS.

This ensures that datetime fields in query results are returned in YYYY-MM-DD HH:MM:SS format.

If this property is used to specify a format that excludes the timezone, the driver will not retrieve timezone information for datetimes, and will be unable to guarantee accurate datetime conversions across timezones.

This property applies only when Schema is set to SuiteQL.