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 |
|
Fredforfree
Starting Member
49 Posts |
 Posted - 2008-04-09 : 09:11:41
|
| Hi Date in original table is in this format2008-03-25 18:57:39.000When i create a view based on this data format changes to04-04-2008 11:12:01 AMI need format to stay the same as tableThanksFred |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-04-09 : 09:18:04
|
Why is the format important to you?
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
Fredforfree
Starting Member
49 Posts |
Posted - 2008-04-09 : 09:21:43
|
Data is then imported into access, querys and tables are all set to original formatquote:
Originally posted by Peso
Why is the format important to you?
E 12°55'05.25"N 56°04'39.16"
Fred |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-04-09 : 09:29:46
|
If the data still is DATETIME or SMALLDATETIME, format is of no importance.
E 12°55'05.25"N 56°04'39.16" |
|
|
|
Fredforfree
Starting Member
49 Posts |
Posted - 2008-04-09 : 09:32:28
|
Question is why does sql change format and how can i prevent it from doing so?Fredquote:
Originally posted by Peso
If the data still is DATETIME or SMALLDATETIME, format is of no importance.
E 12°55'05.25"N 56°04'39.16"
Fred |
|
|
|
elancaster
A very urgent SQL Yakette
1208 Posts |
Posted - 2008-04-09 : 09:35:19
|
| is this really a sql server 2008 question?Em |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-04-09 : 09:37:26
|
Maybe not a SQL Server 2008 specific question?Perhaps this behaviour started for him when creating the view in SQL Server 2008.
E 12°55'05.25"N 56°04'39.16" |
|
|
|
|
|
|
Datetime