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

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

How to place a empty datetime in a Select?

Message

From

31/10/2000 11:51:11

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

To

All

General information

Forum:

Microsoft SQL Server

Category:

SQL syntax

Title:

How to place a empty datetime in a Select?

Miscellaneous

Thread ID:

00436393

Message ID:

00436393

Views:

47

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