|
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 (As-Is product) 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.
|