NEW LISTINGS 
HOT LISTINGS
TOP RATED
EDITOR PICK
ADD A LISTING
UPDATE A LISTING
GET RATED
UPGRADE A LISTING
HOT LISTINGS
TOP RATED
EDITOR PICK
ADD A LISTING
UPDATE A LISTING
GET RATED
UPGRADE A LISTING
Insert Date into Access Database
2650
Insert Date into Access Database
http://www.codefixer.com/codesnippets/insert_date_access_sql.asp
When inserting a date into an Access database you should use the format YYYY-MM-DD. The function AccessDate returns a date in YYYY-MM-DD format.
When working with a date in Access always use the # delimiters in your SQL statement.
The database is called 'dbDate', the table 'tblDate' and date field 'dDate'. The 'dDate' field is a DATE/TIME datatype. ASP > Tips and Tutorials > Date and Time Oct 10, 2006 Michael Wall
When working with a date in Access always use the # delimiters in your SQL statement.
The database is called 'dbDate', the table 'tblDate' and date field 'dDate'. The 'dDate' field is a DATE/TIME datatype. ASP > Tips and Tutorials > Date and Time Oct 10, 2006 Michael Wall
Write a Review
Add to My Favorite
Refer it to Friend
Report Broken Link
| |
|
Other links at ASP > Tips and Tutorials > Date and Time
ASP has a very handy inbuild function called FormatDateTime(). Let's start with the now() function to get the current date and time into a variable
Category:
Learn how to post on a web page using ASP programing the date & time. This tutorial is for beginers and explains in a very simple method how to display the date & time.
Category:
This function is very useful, if you wish to get date of current SQL server date and time. You may use this function to fill some rows automatically with current time or using with DateDiff function to return the number between current time.
Category:
explain how to Dynamically populate a dropdown menu of days dependent om the Month selected. We will be using Javascript and ASP in this article.
Category:
The date and time described in this section are those that are on the server.
Category:
Main Category
178
2033
792
284
174
1802
1113
905
1157
7350
70
898
59
2185
172
Join Mailing List
Joining mailing list will entitle you
to receive occasional emails informing you of news and
updates to the site and any special offers that may be
of interest to you.
Top 10
Directory Statistics
Links: 19152
Categories: 1275
Registered Users: 693
Mailing List Subscribers: 2042
Unique Outgoing Hits: 220469
Pagerank Statistics
PHP News