Will same timestamp conflict in MS Acces database?
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=18478
Printed Date: 13 April 2026 at 7:10am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Will same timestamp conflict in MS Acces database?
Posted By: mbenzp
Subject: Will same timestamp conflict in MS Acces database?
Date Posted: 22 February 2006 at 5:04am
|
I have one quick question. I use MS Access to modify my database (even tho i should switch to the mySQL version ;-/) anyway I have a large amount of topics to post under a catagory so i just copy one row of data in MS Access and paste the same row over and over after i think i have enough and edit the Forum_Name column and the Forum_Order column (so i can have my catagories in alphabetical order) now i use to change the timestamps to be different, but can i leave the Date_Started the same or will that cause any conflicts in the future?- i uploaded it to my site and everything looks good... thanks
|
Replies:
Posted By: WebWiz-Bruce
Date Posted: 22 February 2006 at 10:11am
Access doesn't internally store dates in the way they are displayed.
Access stores dates internally as a double number in milli seconds since December 1899 (or something near that date).
I would just leave Access to sort out the dates, as the forum software in version 8 will convert dates to ISO International format dates to prevent date issues with servers and databases.
-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting
|
Posted By: mbenzp
Date Posted: 22 February 2006 at 11:13am
|
thanks you have saved me headache in the future
|
|