How to place a empty datetime in a Select? - Level Extreme

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

How to place a empty datetime in a Select?

Message

De

31/10/2000 11:51:11

Jean-René Roy
Technologies Softdesign Inc.
Kanata, Ontario, Canada

À

Tous

Information générale

Forum:

Microsoft SQL Server

Catégorie:

Syntaxe SQL

Titre:

How to place a empty datetime in a Select?

Divers

Thread ID:

00436393

Message ID:

00436393

Vues:

49

I need to blank a datetime field in a select. What is the syntax?

Ex:

Select *,
       case 
           When MyFlag = 1
           then MyDateTime
           else { / / } <b> ???</B>
       end as MyNewDateTime
       from MyTable

Jean-René Roy President of http://www.softdesign.qc.ca/
President of http://www.DevTeach.com and http://www.SQLTeach.com

Click here to load this message in the networking platform