| Author: dheeraj swami 03 Jul 2008 | Member Level: Bronze | Rating:  Points: 1 |
HEY u can hange the format using convert
convert(varchar(10),Date,103)
or 101
|
| Author: Aravind 03 Jul 2008 | Member Level: Gold | Rating: Points: 6 |
you need to do some math here.
Convert your given date, by taking the date time value of the given date and take the difference from the current given date's time till 1970,jan 1, 00:00am time and use the second param as type of value as "ms" which may give you in milliseconds.
That is, difference from current date's time till jan 1970 time. and do math for getting the difference in milliseconds.
|