insert date part

[nomu26]

i'm trying to insert part of the date in the database using the function 'DATEPART' with no success i only want to insert the day part not the whole date....
Please help i need to do this urgently

Thanks in advance

 

[DaZZleD]

what database type do you use?

 

[nomu26]

i'm using SQL Server 2003

 

[Modica82]

Why dont u use an Integer field and insert the part you want.

Rob

 

[DaZZleD]

if you only need the day, make the field of type numeric and add constraints... then insert it as a number

 

[nomu26]

can you give me an example then????

 

[DaZZleD]

if your object is of DateTime type then you can get the day by using myDateTime.Day