Update column value by Infinite Date value

Question

question

Ajay 1 asked Jul 9, '10

Update column value by Infinite Date value

Hi, I have one column and i need to update that column based on some condition. Suppose if value = 0 then i need to update that column with never expired date means the infinite date. I dont have any clue for this. Please help me.

Thanks Ajay

query update

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2010-07-09T04:11:53Z

Squirrel 1 answered Jul 9, '10

infinite date ? i suppose you can use 9999-12-31. When that date reach and it didn't expired, let me know ;) Alternatively you can use NULL value. Anything when compare with NULL is false. Depending on your requirement and scenario, you might need to handle NULL specifically in your code

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

question