Empress Software Inc. ~ Empress Embedded Database

Empress Servers

Empress APIs

Empress Utilities

Dev. Environments

Facts and Figures

Free Trial

To Order Empress

Empress Apps for iPad

MICROTIMESTAMP Data Type

Micro-Second Time Stamps allow you to store and retrieve the occurrence of real-time system events down to a millionth of a second.

The MICROTIMESTAMP data type stores TIME plus microseconds information. MICROTIMESTAMP attributes are specified as:

 attr  MICROTIMESTAMP [(type)]

The type is the same as for TIME attributes (i.e. a number from 0 to 8), and specifies the format in which the date part will be printed. If the type is omitted, it defaults to 0.

This data type stores information regarding date and time including the number of microseconds which may range from January 1, 0000 00:00:00.000000 to December 31, 9999 23:59:59.999999 where the last 6 digits in the format represent the number of microseconds.

The nine different MICROTIMESTAMP styles are shown below. The output is for August 28, 1998 2:56:15 p.m. and microseconds.

Empress MICROTIMESTAMP Data Types

Type	Format	Year Range	Example

0	yyyymmddhhmmssffffff	0000-9999	19980828145615234599
1	dd aaaaaaaaa yyyy hh:mm:ss.ffffff	0000-9999	28 August 1998 14:56:15.234599
2	aaaaaaaaa dd, yyyy hh:mm:ss.ffffff	0000-9999	August 28, 1998 14:56:15.234599
3	mm/dd/yy hh:mm:ss.ffffff	nn00-nn99 *	08/28/98 14:56:15.234599
4	dd/mm/yy hh:mm:ss.ffffff	nn00-nn99 *	28/08/98 14:56:15
5	dd aaa yy hh:mm:ss.ffffff	nn00-nn99 *	28 Aug 98 14:56:15.234599
6	aaa dd, yy hh:mm:ss.ffffff	nn00-nn99 *	Aug 28, 98 14:56:15.234599
7	mm/dd/yyyy hh:mm:ss.ffffff	0000-9999	08/28/1998 14:56:15.234599
8	dd/mm/yyyy hh:mm:ss.ffffff	0000-9999	28/08/1998 14:56:15.234599

* nn is defined by the Empress system variable the value of which is assigned by the user to indicate the preferred century for entering dates.

	Company Information GSA Contracts Careers Privacy Policy Contact US	Products Empress RDBMS Empress Servers Empress API Free Trial Empress iPad Apps	Services Consulting Mobile Apps Development Technical Support Training Courses Empress Extreme	Partners Distributors Business Alliances Partner Programs GSA Program Distributors Program	Media Empress Markets News and Events Press releases Technical News Success Stories
USA: 301-220-1919 Canada & International: 905-513-8888 Copyright © 2014 Empress Software Inc. [email protected] Join Empress Mailing List