» Quick Links
You can make money on these forums
We Share profits with you
Google
Google Adsense
Google Adwords
YPN
Yahoo
MSN Search
Web Directories
Web Hosting
Web Hosting Offers
Hosting News
Suggestions
Link Building
Domain Names
PHP Forums
MySQL Forums
» More Links
OSP News
Reseller Hosting
Shared Hosting
Dedicated Servers
Google Adsense
Search Engine Marketing
Link Development
Affiliate Marketing


» Advertising
Multiple DC PR Check

Free SEO Tools


Go Back   Webmaster Forums > Website Developement / Programming > MySQL Forums

MySQL Forums Share Your Ideas and Tips about MYSQL. Ask questions about MYSQL. Table Design and Much More...

Reply
 
Thread Tools Display Modes
  #1  
Old 04-12-2007, 03:55 AM
Anahi Anahi is offline
Junior Member
 
Join Date: Jul 2006
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
Anahi is on a distinguished road
Default storing microseconds in 4.1.12?

Hi people,
Please tell me whether you are able to store microseconds in MySQL version 4.1.12? It doesn't seems possible at this version. Can anyone confirm that for me?
Thanks. -- 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
Revenue Sharing Ads ( ?):
  #2  
Old 04-13-2007, 05:18 AM
evy evy is offline
Senior Member
 
Join Date: Oct 2006
Posts: 111
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 14
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
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
storing a hexadecimal data value? swane MySQL Forums 1 02-01-2007 05:53 AM
storing large volume of data. irwin MySQL Forums 1 12-14-2006 03:21 AM
storing in BLOB's form.... Ewalt MySQL Forums 1 12-11-2006 06:19 AM
storing hexadecimal data into mysql table??? wlinkon MySQL Forums 2 11-25-2006 04:05 AM
Error while storing user information?? Carley MySQL Forums 1 08-14-2006 05:06 AM


All times are GMT. The time now is 01:03 PM.