Select to view content in your preferred language

DateTime Null Problem

1499
2
12-27-2012 09:48 PM
SelçukTınaz
Occasional Contributor
Hi Everyone,

     I have a problem about setting a DateTime field. I am using 10.1 and adding a new feature from silverlight that
has an attribute which type is Date. When attribute value is "null", in Database it saves as 01.01.1970. So, when i query it i
handled 01.01.1970. What i want is; when i set attribute null, it must be set as null not 01.01.1970. I search a lot and find something
about datetime but no about this.

Thanks a lot
0 Kudos
2 Replies
RuiShen
Occasional Contributor
I was able to reproduce this with 10.1 server.
It seems that even if you put in null in the date field, it will automatically get transformed to 0 which in 01/01/1970 or 12/31/1969 depending on which time zone you are in.
0 Kudos
SelçukTınaz
Occasional Contributor
So, is there anyway to set the field to null value or it is impossible. In addition i am using 10.1 too.

Thanks in Advance
0 Kudos