View Single Post
  #2  
Old 04-13-2007, 06:18 AM
evy evy is offline
Senior Member
 
Join Date: Oct 2006
Posts: 111
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 16
evy is on a distinguished road
Default Re: storing microseconds in 4.1.12?

You can store this information, just not as part of the standard DATETIME or TIME fields. You can have an additional field that stores just the microsends or milliseconds.
Or you can have a BIGINT field storing a UNIX timestamp*1000 plus the milliseconds etc. You will also have to provide the time data source yourself. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --
Reply With Quote
  Webmaster Forums - View Single Post - storing microseconds in 4.1.12?
View Single Post
  #2  
Old 04-13-2007, 06:18 AM
evy evy is offline
Senior Member
 
Join Date: Oct 2006
Posts: 111
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 16
evy is on a distinguished road
Default Re: storing microseconds in 4.1.12?

You can store this information, just not as part of the standard DATETIME or TIME fields. You can have an additional field that stores just the microsends or milliseconds.
Or you can have a BIGINT field storing a UNIX timestamp*1000 plus the milliseconds etc. You will also have to provide the time data source yourself. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --
Reply With Quote