Click here to Skip to main content
12,951,034 members (49,362 online)
Rate this:
 
Please Sign up or sign in to vote.
Hi Experts,


I have one Stores.dbml file in my application.
this having 10 table designs.

for one of table having field "end_time"
The properties are as follwos
Type: DateTime (System.DateTime)
Server Data Type : DateTime

end_time field in database is of DateTime.

If i want to change DateTime to SmallDateTime in application ( not in database)
where i need to modify??

Please Help me.

Thanks in Advance.
Posted 20-Nov-12 18:42pm

1 solution

Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

Hi,

Type your date time with "d", And you need to typecast datetime after retrival from the DB. Refer the below link for more information.

http://msdn.microsoft.com/en-us/library/az4se3k1.aspx[^]
  Permalink  
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

    Print Answers RSS
Top Experts
Last 24hrsThis month
OriginalGriff 6,084
CHill60 3,480
Maciej Los 3,083
Jochen Arndt 1,975
ppolymorphe 1,830


Advertise | Privacy | Mobile
Web01 | 2.8.170525.1 | Last Updated 21 Nov 2012
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100