Home Microsoft SQL Server DigiMailing Contact
    Keyword



Converting datetime field

 

To convert a datetimefield to a string you can use the next configurations

select convert(nvarchar,getdate(),<nr>)
Nr Sybase ASE MS SQL Server
101 12/04/2009 12/04/2009
102 2009.12.04 2009.12.04
103 04/12/2009 04/12/2009
104 04.12.2009 04.12.2009
105 04-12-2009 04-12-2009
106 04 Dec 2009 04 Dec 2009
107 Dec 04, 2009 Dec 04, 2009
108 11:13:58 11:07:54
109 Dec 4 2009 11:13:58:206AM Dec 4 2009 11:07:54:263AM
110 12-04-2009 12-04-2009
111 2009/12/04 2009/12/04
112 20091204 20091204
113 2009/04/12 04 Dec 2009 11:07:54:263
114 12/2009/04 11:07:54:263
120   2009-12-04 11:07:54
121   2009-12-04 11:07:54.263

 




Syntax
Last revision
News

  Query a named instance
Sybase+ASE+silent+install
SQL 2008 R2
Deprecated procedures in SQL2008
Reporting Services item-level role definitions
Create all your missing indexes
Converting datetime field
Start MSSQL Server Profiler at time
Replicating MSSQL Server views
Exploring Microsoft Sharepoint
The OLE DB provider "SQLNCLI10" for linked server indicates.
Mobile solar charger
Oracle to SQL Server replication
Cannot insert the value NULL into column
Undocumented Microsoft SQL Server 2008
VMware
Zoekmachine optimalisatie
SQL Servers hidden objects
FckEditor
Flash in Ajax
De hype die AJAX heet
Barcode scannen
MySQL; Gratis, makkelijk en snel!
PHP
sIFR; de combinatie tussen HTML en Flash