ms sql server default value on server for date

Steve Garlan

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

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

Name

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

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

1. Delphi 3.0 - IIS ISAPI + SQL Server (MS) + BDE = SQL Server not found errors

2. Obtaining the value to be 'Default-'ed from SQL Server 7 via ADOX

3. SQL Server 6.5 and Default Values

4. Problems with default values in SQL Server

5. Default id generator in MS SQL Server 7.0

6. TUpdateSQL and defaults in MS SQL Server

7. TUpdateSQL and defaults on MS SQL Server 6.5

8. MS SQL Server 7, ClientDatasets and miliseconds in Dates

9. Problem of date with DELPHI and MS SQL SERVER

10. How To Send NULL Values to an MS-SQL Server With ADO