Question: What are some issues that may arise when using dates and working with databases? [ Print this FAQ]
Answer: One of the trickiest parts for developers when using databases is working with date fields. I think every developer has, at one time or another, spent more time than he or she would like to admit trying to get a date field into the right syntax, or properly formatting a SQL string that contained a date field. Things only become more complicated when working outside of North America, where date formats are often represented as
dd/mm/yyyy as opposed to the more-American way of:
There are already a number of articles on 4Guys and ASPFAQs.com so this FAQ will list the most useful articles for learning about how to work with dates and squeeze them into the right format! Working with Dates and Databases - Related Articles: -- If you are wanting a simple way to format dates into a standard that is accepted by both Microsoft Access and Microsoft SQL Server, check out Doug Dean's article: How To Code For Compatible Date Formats for Access and SQL Server. -- If you are working with dates in the non-North American standard (that is, if you are working with dates in
dd/mm/yyyy format instead of
mm/dd/yyyy format) be sure to check out Darren Neimke's article:
Working with Databases and International Date Formats. -- If you need to retrieve records based on those who have a date/time column that falls within a certain range, check out this FAQ by Bill Wilkinson. If you know of any other good date/databases-related articles be sure to let me know! Happy Programming!
FAQ posted by Scott Mitchell at
4/9/2001 5:22:38 PM to the
Databases, General category.
This FAQ has been viewed 47,730 times.
Do you have a FAQ you'd like to suggest?
Suggestions? Comments? If so,
send it in!
Also, if you'd like to be a FAQ Admin (creating/editing FAQs),
let me know! If you are looking for other FAQs, be
sure to check out the 4Guys
FAQ and Commonly Asked Messageboard Questions!
Most Viewed FAQs: 1.) How can I format numbers and date/times using ASP.NET? For example, I want to format a number as a currency. ( 761643 views)
2.) I am using Access and getting a 80004005 error (or a (
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)' error) when trying to open a connection! How can I fix this problem?
3.) How can I convert a Recordset into an array? Also, how can I convert an array into a Recordset? ( 202549 views)
4.) How can I quickly sort a VBScript array? ( 196039 views)
5.) How can I find out if a record already exists in a database? If it doesn't, I want to add it. ( 156019 views)
6.) How do I display data on a web page using arrays instead of Do...While...MoveNext...???... ( 152331 views)
7.) When I get a list of all files in a directory via the (
FileSystemObject, they aren't ordered in any reasonable way.
How can I sort the files by name? Or by size? Or by date created? Or...
8.) For session variables to work, must the Web visitor have cookies enabled? ( 110162 views)
9.) Can I send emails ( without using CDONTS? 107083 views)
10.) How can I take the result of a ( SELECT...MULTIPLE or a group of same-named checkboxes and turn it into a query? That is, if the user selects 3 answers, how can I construct a query that looks for all 3? 106308 views)
Last computed at 9/17/2007 3:22:00 AM