I like this idea. I am in the final stages of updating my database to replace
many individual date&time values used for audit purposes with a single
DATETIME value.
Many parts contained only DATE values.I needed a way to distinguish multiple
changes/deletes/inserts made on a single day.. Instead of separate DATE and
TIME
fields I went with the single DATETIME values.
Jim Bentley
American Celiac Society
[RBASE-L] - Re: Datetime tutorial
Dennis McGrath
Wed, 17 Oct 2012 06:34:57 -0700
Parhaps one of these days we will see: DTDiff(datetime,datetime) returns a
string in the format
'Days,Hours,Minutes,Seconds'
i.e. DTDiff('10/1/2012 12:45:00 PM','10/2/2012 3:01:03 AM')
returns '0,2,16,3' regardless of the time settings. Dennis McGrath
Software Developer
QMI Security Solutions
1661 Glenlake Ave
Itasca IL 60143
630-980-8461
[email protected]
Jim Bentley,
American Celiac Society
1-504-737-3293
