|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
April 24th, 2001, 02:19 AM
|
|||
|
|||
|
formatting the date
<i><b>Originally posted by : narmada</b></i><br />will u plse tell me how to get the time in sql server 7.0<br />
|
|
#2
May 7th, 2001, 08:18 AM
|
|||
|
|||
|
<i><b>Originally posted by : RJbreddy (jb.reddy@finessealliance.com)</b></i><br />WILL u plse tell me how to get the time in sql server 7.0<br /><br />bY APPLYING GetDate() in sql query we can get but by using convert () function we can get in what ever format we want, this convert function takes three parameters, the third parameter will be from 100 onwards to get different formats.Please try this and let me know<br />JB<br />RJBREDDY@yahoo.com
|
|
| Viewing: ASP Free Forums > Database > SQL Development > formatting the date |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
