There are several different ways of displaying dates. You can also add and subtract from them as well. Using the FormatDateTime function we can display dates in any manner.
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
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. .