|
|
|
Monday, 26 December 2011 23:53 |
In SQL Server used Cast or Convert function to Format DateTime value or column into a specific date format.Both function are used to convert datetime to varchar or string.
CAST(expression as data_type)
Let's convert current date time to varchar
select cast(getdate() as varchar)
CONVERT function is used to change or convert the DateTime formats.By using convert function you can get only Date part or only Time part from the datetime.
CONVERT Function Syntax:
CONVERT(data_type,expression,date Format style)
 Read more: |
|
|
|
|
Monday, 24 January 2011 12:32 |
a little helper function which parses about any date and returns the same date in MySQL date/time format Download Wow Hits 2010 2011
function date_to_mysql($date) {
//if $date is not numeric, assume it's in textual format
if (!is_numeric($date)) {
$date=strtotime($date);
}
return date('Y-m-d H:i:s',$date);
}
 Read more: |
|
Monday, 08 November 2010 03:00 |
 | About Stash
A free, fast, simple personal finance application. Supports multiple accounts, split transactions, localized currency and date formatting, scheduled transactions, graphs, QIF/OFX import/export. |
Read more: |
|
|
|
|
|
|
Page 1 of 2 |