Filling SQL date field with empty date? - Level Extreme

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Filling SQL date field with empty date?

Message

From

19/11/2003 15:23:08

Harry Stottle
United Kingdom

To

19/11/2003 15:13:18

Mark McCasland
Midlothian, Texas, United States

General information

Forum:

Visual FoxPro

Category:

Databases,Tables, Views, Indexing and SQL syntax

Title:

Re: Filling SQL date field with empty date?

Miscellaneous

Thread ID:

00851431

Message ID:

00851622

Views:

7

>Try:
>
>update vizkeys set date_used=NULL where date_used IS NOT NULL

yesss!

Thankyou. That did it.

Click here to load this message in the networking platform