Search


	Podcast:		voiceofthedba's podcast
	Episode:		Capture the Application Time
	Category:		Technology
	Duration:		00:02:26
	Publish Date:		2019-04-15 16:00:00
	Description:		I've always thought that any times we recorded in a row were related to the actual data itself. Almost all of the time I've built software, we've assumed that the time a row is written or updated is the time we need to record as a timestamp. This works great for many applications and it certainly simplifies programming when the database can capture the time. System versioned tables are a great example of where we use time in the database as the time of record.Over the years we've started to build more distributed applications that reach a widely dispersed audience. With the Internet today, it's entirely possible that a row inserted by one user takes place in time zones far away from the next row inserted by a different user. What may be more confusing is that I may insert a row in GMT/UTC, but then update that row a day later in the Mountain Standard Time time zone. In fact, that's something I've done. Read the rest of Capturing the Application Time
	Total Play:		0