SQL script, how to clear a date field

Roelof · 2015-12-16

I'm currently writing a SQL script to clear a date field of a NAV table. If I clear it as a blank it will give me a weird sql date format and I'm not able to run the table or record. Any idea how to do this? PS: a 'NULL' value or 0 doesn't work either.

mohana_cse06 · 2015-12-16

I guess you need to use 1900-01-01

Remco_Reinking · 2015-12-16

If it should be the empty date for NAV, you should populate it with 1753-01-01

EvR · 2015-12-16

NAV doesn't do NULLs... That's the thing I am most frustrated about when it comes to NAV. Well, that and the DATE, TIME, and DATETIME types

The earliest value you can store in SQL server is '1 Jan 1753 00:00:00.000'. So that's what NAV uses as an 'empty' date. NULL would be more elegant but that's not an option in NAV.

Roelof · 2015-12-24

Thanks you all. Yes I finally figured this out. and I need to use the '1753 00:00:00.000' string instead of the NULL value.

DenSter · 2015-12-24

'1753-01-01 00:00:00.000' don't forget the month and day

Howdy, Stranger!

Quick Links

Categories

SQL script, how to clear a date field

Answers