[Year 12 SofDev] Time/Date Data Type

Wed Nov 13 11:57:10 EST 2013

>From http://support.microsoft.com/kb/210276
The following table shows how Access stores Date/Time values:

   Double         Date      Actual             Time      Actual
   number         portion   date               portion   time
   ------------------------------------------------------------------

        1.0           1     December 31, 1899  .0        12:00:00 A.M.
        2.5           2     January 1, 1900    .5        12:00:00 P.M.
    27468.96875   27468     March 15, 1975     .96875    11:15:00 P.M.
    36836.125     36836     November 6, 2000   .125       3:00:00 A.M.

To muddy the water here is how IBM's DB2 handles them (from http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=%2Fcom.ibm.db2z10.doc.intro%2Fsrc%2Ftpc%2Fdb2z_datetimetimestamp.htm)

DB2(r) stores values of datetime data types in a special internal format. When you load or retrieve data, DB2 can convert it to or from any of the formats in the following table.
Table 2. Date and time format optionsFormat name        Abbreviation      Typical date        Typical time
International Standards Organization      ISO         2003-12-25          13.30.05
IBM(r) USA standard        USA       12/25/2003         1:30 PM
IBM European standard                EUR        25.12.2003           13.30.05
Japanese Industrial Standard Christian Era            JIS           2003-12-25          13:30:05

From: sofdev-bounces at edulists.com.au [mailto:sofdev-bounces at edulists.com.au] On Behalf Of Anthony Sullivan
Sent: Wednesday, 13 November 2013 11:44 AM
To: 'sofdev at edulists.com.au'
Subject: [Year 12 SofDev] Time/Date Data Type

Is it correct that Time/Date type data will be stored as an integer?

Anthony Sullivan
Head of Information Technology

20 Wooralla Drive, Mt. Eliza, Vic, 3930

T: 03 9788 7796 | F: 03 9787 7646 | asullivan at tps.vic.edu.au<mailto:asullivan at tps.vic.edu.au> | www.tps.vic.edu.au<http://www.tps.vic.edu.au>

[cid:image001.gif at 01CEE067.7BB42560]

[cid:image002.gif at 01CEE067.7BB42560]<http://www.facebook.com/pages/The-Peninsula-School/118935504829400?ref=hl> [cid:image003.gif at 01CEE067.7BB42560] <http://https:/twitter.com/TPSMtEliza>  [cid:image004.gif at 01CEE067.7BB42560] <http://www.youtube.com/user/ThePeninsulaSchool>

Please consider the environment before printing this email, you will save 5g of paper, 250mL of water and at least 35gm of CO2

This message, including any attachments, is provided without responsibility in law for its accuracy or otherwise and without assumption of a duty of care by the school. Whilst every attempt has been made to ensure material in this e-mail message is free from computer viruses or other defects, the attached files are provided, and may only be used, on the basis that the user assumes responsibility for the use of the material transmitted. This e-mail is intended for the use of the named individual or entity and may contain confidential and privileged information. Any dissemination, distribution or copying by anyone other than the intended recipient of this e-mail is strictly prohibited. If this e-mail has been received in error then please notify The Peninsula School immediately and destroy the original message.

Important - This email and any attachments may be confidential. If received in error, please contact us and delete all copies. Before opening or using attachments check them for viruses and defects. Regardless of any loss, damage or consequence, whether caused by the negligence of the sender or not, resulting directly or indirectly from the use of any attached files our liability is limited to resupplying any affected attachments. Any representations or opinions expressed are those of the individual sender, and not necessarily those of the Department of Education and Early Childhood Development.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/sofdev/attachments/20131113/ec809cb9/attachment-0001.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.gif
Type: image/gif
Size: 13580 bytes
Desc: image001.gif
Url : http://www.edulists.com.au/pipermail/sofdev/attachments/20131113/ec809cb9/image001-0001.gif 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.gif
Type: image/gif
Size: 2566 bytes
Desc: image002.gif
Url : http://www.edulists.com.au/pipermail/sofdev/attachments/20131113/ec809cb9/image002-0001.gif 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.gif
Type: image/gif
Size: 2578 bytes
Desc: image003.gif
Url : http://www.edulists.com.au/pipermail/sofdev/attachments/20131113/ec809cb9/image003-0001.gif 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image004.gif
Type: image/gif
Size: 2695 bytes
Desc: image004.gif
Url : http://www.edulists.com.au/pipermail/sofdev/attachments/20131113/ec809cb9/image004-0001.gif 