how to hndle month

[mak1084]

hello friends i'm creting databas in SQL server..
in this data base i have to store only month and year not date then which data type i use for this...


thanks

[allik7]

hello friends i'm creting databas in SQL server..
in this data base i have to store only month and year not date then which data type i use for this...


thanks

Why not use datatype char/varchar

[mak1084]

Why not use datatype char/varchar

to do a validation i thik it will be better..in case a user enters a wrong month or year..

[Delerna]

I doubt there is a date data type that has only month and year
You will need to use a char/varchar/int and perform your validation at the front end

[ck9663]

though it's always recommended to do the validation in the front-end as a part of your apps, it's also recommended to protect the table from invalid data that did not pass through the apps (sql analyzer - insert, etc...)...use CONSTRAINT or TRIGGER depending on your requirement...

-- ck

[jimmylee]

hey friend,

pls use varchar datatype.

[amitpatel66]

hello friends i'm creting databas in SQL server..
in this data base i have to store only month and year not date then which data type i use for this...


thanks

Use VARCHAR datatype ans store the date value in MMYYYY format.
In front end app where you do validation, fetch first two characters for month and last four for years and validate. I hopw this helps!!

[mak1084]

hey thanks every one.. you guys helped me a lot.