DB_TIME_FORMAT

For

Database Logger

Project

Purpose

To define the time stamp format for your database so that time and date fields will be written correctly in the Store and Forward files. This parameter is for a database that does not use the default Microsoft Access and SQL Server time stamp format, which is used by CIMPLICITY.

Value

Timestamp (is case sensitive):

 

Uppercase

 

Y

Year

 

M

Month

 

H

Format options for the Hour specification are:

 

 

HHHH

 24-hour

Note: The 24-hour format is used for Alarm logging and Point logging files stored by default  in the %SITE_ROOT%\arc directory.

 

 

HH

12-hour

Include one of the following to specify AM or PM.

 

 

 

A

AM

 

 

 

P

PM

 

Lowercase

 

d

Day

 

m

Minutes

 

s

Seconds

 

t

Ticks (100 ticks=1 second)

Default Value

Microsoft Access and SQL Server times tamp format.

 

 

More information

Global parameters.