1

I need to insert my date values on website application to it's sqlserver table, but in solar date format. The problem is, The first month until the sixth month, the days counts are 31 days, in solar calendar and when I insert for ex: 1394-02-31
, enter image description here

sql server give me an error that

enter image description here

, because february has not 31 days.
So I try to add some new datatype that derived from date datatype as below fig:

enter image description here


but I'm confused when I want to fill values.

enter image description here

So, Please help me to solve my problem, are there any sources to show me how to add new date datatype in sqlserver 2008?

Community
  • 1
  • 1
Reza Paidar
  • 863
  • 4
  • 21
  • 51
  • http://stackoverflow.com/questions/10948351/is-it-possible-to-change-the-datatype-date-in-sql-server Same question was raised earlier, some good suggestions here but no absolute solutions. – d_luffy_de Oct 09 '15 at 07:05
  • In case you try to go with solution suggested in that question (pointed by Darshan): http://www.databaseskill.com/4316542/ – Deep Kalra Oct 09 '15 at 07:10
  • Thanks @DarshanBI-DW , But they mean create function or somting like this. I want create new my own dataType not any converter function :( – Reza Paidar Oct 09 '15 at 08:56

0 Answers0