SQL parameters: sqltextdateformat

Startup parameters change the behavior of the Service Manager server. You can always set a startup parameter from the server's operating system command prompt.

Parameter

sqltextdateformat

Description

You may find the unable to convert value of field xxx from type STRING2 to type ARRAY. error message in the sm.log file when both of the following conditions are met:

  • The format of the input date/time data as a character string does not match the current user's date/time format setting
  • The system needs to convert the string to an array field of Service Manager

To solve this problem, use the sqltextdateformat parameter to specify the date/time format of this input string.

Valid if set from

Server's operating system command prompt

Initialization file (sm.ini)

Requires restart of the Service Manager server?

Yes

Default value

None

Possible values

Date formats

  • YYYY/MM/DD
  • YY/MM/DD
  • MM/DD/YYYY
  • MM/DD/YY
  • DD/MM/YYYY
  • DD/MM/YY

Example usage

Command line: sm -httpPort:13080 -sqldb:dbserver -sqltextdateformat:MM/DD/YYYY

Initialization file: sqltextdateformat:MM/DD/YYYY

Note You should only use this parameter prior to conversion. Using it or changing it does not work for a converted system.

Related topics

System parameters
Enter a parameter in the sm.ini file
Database parameters