Or simply drop the first character - day 20000 isn't until October 2022 - simple prefix a "1" to first 4 digits
Ross Ferris Stamina Software Visage > Better by Design! >-----Original Message----- >From: [EMAIL PROTECTED] [mailto:owner-u2- >[EMAIL PROTECTED] On Behalf Of Brad Moll >Sent: Wednesday, 13 September 2006 8:53 AM >To: [email protected] >Subject: RE: [U2] Time/Date as a single number > >If you want a smaller number and you don't have to really worry about >historical dates, you could shift the date and use 1/1/2000 as day 1 by >subtracting 11688 from the date before you do the multiplication. > >Brad Moll >JK Consulting Services, Inc. >Phone: (763)754-5354 >Fax: (763)463-1750 > >-----Original Message----- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] On Behalf Of Steve Johnson >Sent: Tuesday, September 12, 2006 4:31 PM >To: [email protected] >Subject: Re: [U2] Time/Date as a single number > >In my application, I add a constant (134408) to the date so that it is >always > 0. Then I right-justify and zero-fill to a constant length both >date (plus constant) and time and delimit them with a literal ":". This >gives me a non-numeric string with a constant length by which I can sort >if >need be. > >FWIW, the constant 134408 works with dates back to 1-Jan-1600. (Dates >earlier than year 1583 don't seem to work on UniData.) > >Steve Johnson > >On 9/12/06, George Gallen <[EMAIL PROTECTED]> wrote: >> OK. what is the ?best? way to store the time/date (to the second) as a >> single number >> similar to unix's epoch, although I'm not looking to convert it to >> unix format. >> >> My method is take date()*86400+time() >> idate=int(combo/86400), itime=combo-(idate*86400) >> >> Is there anyway to do this giving less than 10 characters (and stay in >> base >> 10) ? >> >> George Gallen >> Senior Programmer/Analyst >> Accounting/Data Division >> [EMAIL PROTECTED] >> ph:856.848.1000 Ext 220 >> >> SLACK Incorporated - Delivering the best in health care information >> and education worldwide. >> http://www.slackinc.com >> ------- >> u2-users mailing list >> [email protected] >> To unsubscribe please visit http://listserver.u2ug.org/ >------- >u2-users mailing list >[email protected] >To unsubscribe please visit http://listserver.u2ug.org/ >------- >u2-users mailing list >[email protected] >To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
