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
Using GetDate Function in an SQL Statement
2655
Using GetDate Function in an SQL Statement
http://www.dotnetindex.com/read.asp?articleID=63
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.
ASP > Tips and Tutorials > Date and Time
Oct 10, 2006
Write a Review
Add to My Favorite
Refer it to Friend
Report Broken Link
| |
|
||
| Bookmark Using GetDate Function in an SQL Statement: |
|||
Other links at ASP > Tips and Tutorials > Date and Time
In this source code, you may see how can you display date in diffrent formats. This simple ASP code displays current time in short, long and regional settings.
Category:
The Now() command is a great thing, but sometimes you need to display it different, this is how. Try the following.
Category:
Self explaining sort scripts to compare dates. You may use them to display your age, time period fromm a given date or happening etc. (DateDiff, Timer)
Category:
With DatePart() function in VBScript language you could take only some parts of current time and display/use in your applications. Following examples will show you and give a brief on this function. .
Category:
5. Form Dates
There are a number of ways to have users input dates into your application. Dropdown menus are the preferred method employed as there will certainly be less error checking on dropdown input as compared to textbox input. Utilizing the date() functions the current date (or any date you prefer by adjusting the date value) can easily be made the pre-filled selected value. The first of two examples displays the current date with a range of days prior. The second displays the current date out of all the dates in a range of years.
Category:
Main Category
194
2041
824
286
175
1802
1238
913
1163
7489
70
909
59
2222
174
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: 19539
Categories: 1275
Registered Users: 750
Mailing List Subscribers: 2046
Unique Outgoing Hits: 228067
Pagerank Statistics
PHP News