There are various ways to display Dates and Times. You can display the Date like at the top right of this page or you can display it in the standard MM/DD/YYYY. You can display the Date with the Time or the Time all by itself. You can also abbreviate the name of the Day or display the Time in either 24 hour or 12 hour format.
This is an useful but not known functions. If you wish to learn month of date stored in a database, you may use this function placing in a 'SELECT' sql statement
In this tutorial we will compare dates. We will use DateDiff function. You may compare any two valid dates calculation year, day, month, week, minute ans seconds.
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.
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. .
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.