Company

Products

Services

Partners

Media

 

 

 

Home

Empress RDBMS


Product Features
Key Benefits


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.           info@empress.com           Join Empress Mailing List