Unix Timestamp in Filepro

[Rod Caddy]

ryan at bulldogsoftware.com wrote:
> On Fri, Oct 07, 2005 at 06:30:37AM -0500, Rod Caddy said:
> 
> 
>>I need to generate a Unix timestamp to interface with an sql system.  My
>>precision has to be to the micro-second and we will be calculating from 
>>01/01/2005 1 second.  This will be done on a SCO Unix 5.0.5 system with 
>>4.5 filepro.  I am either having a brain fart and can not find what I 
>>need or am clueless.  I do not know which is more embarrassing.  Thanks 
>>for your input.
> 
> 
> Here is one way:
> 
> date +%Y%m%d%H%M%S
> 
> and if you can handle nanoseconds:
> 
> date +%Y%m%d%H%M%S.%N
> 
I think I have it figured out. I found the number of seconds per day and 
filepro can give me days and seconds since midnight.  I can create a 
formula from that. Thanks for all your suggestions.

-- 
Rod Caddy
Pro-Set Systems
rcaddy at pro-set.com