The Web Design Group

... Making the Web accessible to all.

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> MySQL TIMESTAMP
Christian J
post Oct 23 2010, 10:06 AM
Post #1


.
********

Group: WDG Moderators
Posts: 9,656
Joined: 10-August 06
Member No.: 7
Since the TIMESTAMP type doesn't save microseconds, how do you prevent close events from getting identical time values in a DB table's date column?
User is offlinePM
Go to the top of the page
Toggle Multi-post QuotingQuote Post
Ephraim F. Moya
post Oct 23 2010, 02:24 PM
Post #2


Advanced Member
****

Group: Members
Posts: 167
Joined: 2-September 07
From: New Mexico
Member No.: 3,702
QUOTE(Christian J @ Oct 23 2010, 09:06 AM) *

Since the TIMESTAMP type doesn't save microseconds, how do you prevent close events from getting identical time values in a DB table's date column?


You don't.
User is offlinePM
Go to the top of the page
Toggle Multi-post QuotingQuote Post
Brian Chandler
post Oct 25 2010, 09:38 AM
Post #3


Jocular coder
********

Group: Members
Posts: 2,460
Joined: 31-August 06
Member No.: 43
Good answer, Ephraim. To elaborate slightly, you don't rely on two events having different times, whether it saves microseconds or not.
User is offlinePM
Go to the top of the page
Toggle Multi-post QuotingQuote Post
« Next Oldest · Databases · Next Newest »
 

Reply to this topicStart new topic
2 User(s) are reading this topic (2 Guests and 0 Anonymous Users)
0 Members:

 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

- Lo-Fi Version Time is now: 25th April 2024 - 05:23 AM
Invision Power Board © 2024  IPS, Inc.
Licensed to: HTMLHelp.com, LLC