>Is there a way to utilize the datetime data type in its compressed state? In a table it only requires 8 bytes to store what displays as 19 characters or 14 characters if you remove the non-numeric chars. I want to create a unique character string that incorporates the datetime value plus the rightmost 3 chars from the seconds() function. I looked at using the Julian date, but it does not have the time part that I need. If there is a simpler, better way of doing this, please let me know. Thanks for any help you can give.
>Colombo.
? 0H+BINTOC(DATETIME()-{^1899-12-30:},"8")