Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tahseenm
Yak Posting Veteran
64 Posts |
 Posted - 2006-12-06 : 11:51:42
|
| I create back end table on SQL Server and front end in Access. On my sql table I select the datatype as date/time and on the default value on the field I put this one (dateadd(day,datediff(day,0,getdate()),0). When I input the data in to a SQL table and refresh its showing correct as 12/06/2006. But when I checked in access its showing the date data as 2006-12-06 00: but I want to show 12/06/2006. Can you tell what I have to do SQL table default field to come out like 12/06/2006 not 2006-12-06 00:. Thanks and appreciate your comments.moetahsen |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2006-12-06 : 11:55:33
|
this is something you have to in the Access. i think there's a Format function to do this.Format of the date has no meaning in sql server. it's stored as a decimal.Go with the flow & have fun! Else fight the flow  blog thingie: http://weblogs.sqlteam.com/mladenp |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-12-06 : 23:33:50
|
| >>but I want to show 12/06/2006. If you want to show it in Access make use of Format functionMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
SQL Table Date/time stamp