Board index » delphi » ms sql server default value on server for date

ms sql server default value on server for date

what's the syntax in the enterprise manager to set an ms sql server datetime
field to now?

I searched the on line books!<g>

--
Steve Garland sgarl...@astatech.com
Does your Database run on the Internet? It can!
ASTA: Internet-Ready Client/Server Products & Services
ASTA Technology Group http://www.astatech.com

 

Re:ms sql server default value on server for date


Steve,

getdate()

Go back to BOL and perform a search on "date functions".
Look up CONVERT also.

Dan

Quote
Steve Garland wrote:
> what's the syntax in the enterprise manager to set an ms sql server datetime
> field to now?

> I searched the on line books!<g>

> --
> Steve Garland sgarl...@astatech.com
> Does your Database run on the Internet? It can!
> ASTA: Internet-Ready Client/Server Products & Services
> ASTA Technology Group http://www.astatech.com

Other Threads