6.5 server dates not showing dates with ss:fff

When i view a date on sql 6.5 it is showing as '22 Nov 2004 14:50', if
however i convert it to char 109 it gives me the full date ie 'Nov 22 2004
2:50:56:477PM'. Is there a setting on either the pc or sql that is causing
this ?
Thanks in advance.What application are you using to view the date? This is a pure client application issue, so this is
where you should look for such a setting. More info on datetime:
http://www.karaszi.com/SQLServer/info_datetime.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"billu" <billu@.discussions.microsoft.com> wrote in message
news:AC7E65A4-3F5C-4BF8-92BB-9EC9F8D17AE6@.microsoft.com...
> When i view a date on sql 6.5 it is showing as '22 Nov 2004 14:50', if
> however i convert it to char 109 it gives me the full date ie 'Nov 22 2004
> 2:50:56:477PM'. Is there a setting on either the pc or sql that is causing
> this ?
> Thanks in advance.|||i am using isql to view results. For some reason it only returns back a small
part of the time field, it is only when i convert it that i get the full date.
I have looked at the site but am still none the wiser ?
"Tibor Karaszi" wrote:
> What application are you using to view the date? This is a pure client application issue, so this is
> where you should look for such a setting. More info on datetime:
> http://www.karaszi.com/SQLServer/info_datetime.asp
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> http://www.sqlug.se/
>
> "billu" <billu@.discussions.microsoft.com> wrote in message
> news:AC7E65A4-3F5C-4BF8-92BB-9EC9F8D17AE6@.microsoft.com...
> > When i view a date on sql 6.5 it is showing as '22 Nov 2004 14:50', if
> > however i convert it to char 109 it gives me the full date ie 'Nov 22 2004
> > 2:50:56:477PM'. Is there a setting on either the pc or sql that is causing
> > this ?
> > Thanks in advance.
>
>|||OK, so the programmers who wrote ISQL decided to display the datetime in that particular way. I
suggest that you use CONVERT to get the desired display format for your datetime values.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"billu" <billu@.discussions.microsoft.com> wrote in message
news:BA62CD8F-2512-427F-B078-ABB245743D4B@.microsoft.com...
>i am using isql to view results. For some reason it only returns back a small
> part of the time field, it is only when i convert it that i get the full date.
> I have looked at the site but am still none the wiser ?
> "Tibor Karaszi" wrote:
>> What application are you using to view the date? This is a pure client application issue, so this
>> is
>> where you should look for such a setting. More info on datetime:
>> http://www.karaszi.com/SQLServer/info_datetime.asp
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> http://www.sqlug.se/
>>
>> "billu" <billu@.discussions.microsoft.com> wrote in message
>> news:AC7E65A4-3F5C-4BF8-92BB-9EC9F8D17AE6@.microsoft.com...
>> > When i view a date on sql 6.5 it is showing as '22 Nov 2004 14:50', if
>> > however i convert it to char 109 it gives me the full date ie 'Nov 22 2004
>> > 2:50:56:477PM'. Is there a setting on either the pc or sql that is causing
>> > this ?
>> > Thanks in advance.
>>|||Take a look at your workstation's Regional Settings from the Control Panel.
Also, take a look at the ISQL(/w) settings to see if you've got it set up to
default to your workstation's Regional Settings.
Sincerely,
Anthony Thomas
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uy$0Q317EHA.3828@.TK2MSFTNGP09.phx.gbl...
OK, so the programmers who wrote ISQL decided to display the datetime in
that particular way. I
suggest that you use CONVERT to get the desired display format for your
datetime values.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"billu" <billu@.discussions.microsoft.com> wrote in message
news:BA62CD8F-2512-427F-B078-ABB245743D4B@.microsoft.com...
>i am using isql to view results. For some reason it only returns back a
small
> part of the time field, it is only when i convert it that i get the full
date.
> I have looked at the site but am still none the wiser ?
> "Tibor Karaszi" wrote:
>> What application are you using to view the date? This is a pure client
application issue, so this
>> is
>> where you should look for such a setting. More info on datetime:
>> http://www.karaszi.com/SQLServer/info_datetime.asp
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> http://www.sqlug.se/
>>
>> "billu" <billu@.discussions.microsoft.com> wrote in message
>> news:AC7E65A4-3F5C-4BF8-92BB-9EC9F8D17AE6@.microsoft.com...
>> > When i view a date on sql 6.5 it is showing as '22 Nov 2004 14:50', if
>> > however i convert it to char 109 it gives me the full date ie 'Nov 22
2004
>> > 2:50:56:477PM'. Is there a setting on either the pc or sql that is
causing
>> > this ?
>> > Thanks in advance.
>>