Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

In my database i have information about when my customers are born (date format). However i see an unnatural peak in people born 1 february 1965...

I do not have access to the code writing this information to my database. But i know that there is a problem in some languages when null or 0 or other invalid characters are given to a date function. Is there any language that have 1. february 1965 as a default?

I believe the problem originates from the order form on my website.

share|improve this question
    
What RDBMS are you working with? SQL Server allows you to set a default value on a column if one is not provided with each insert, could be your issue here. –  Shawn Melton Sep 6 '13 at 14:50
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.