URGENT CONVERT FUNCTION - SQL Server Forums

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.

All Forums

General SQL Server Forums

New to SQL Server Programming

URGENT CONVERT FUNCTION

Author

Topic

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2007-09-14 : 12:47:44

CAN SQL GURUS(PESO,MADHAVAN,VOLTER,KRISTEN) PROVIDE ME EXAMPLE OF CONVERT AND CAST FUNCTION CLEARLY WITH EXAMPLE

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-09-14 : 12:54:45

and books online doesn't help clearly?

and please don't post with capital letters.

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2007-09-14 : 12:56:07

NO SPIRIT ....JUST ONE EXAMPLE

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-09-14 : 12:56:24

There is this topic to follow
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=80563

E 12°55'05.25"
N 56°04'39.16"

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2007-09-14 : 12:58:59

Thanks Peso

Peso is the master of yaks....

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-09-14 : 13:00:37

i still can quite understand how is this not clearly explained in BOL?

can you please explain that??

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-09-14 : 13:04:47

No, I can't.
Maybe they resist opening another application? Maybe it's easier to just browse to a new page?

E 12°55'05.25"
N 56°04'39.16"

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-09-14 : 13:05:47

i wasn't asking you peter

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-09-14 : 20:22:47

quote:
Originally posted by Peso

No, I can't.
Maybe they resist opening another application? Maybe it's easier to just browse to a new page?

E 12°55'05.25"
N 56°04'39.16"

Yes. a new page it will be. http://msdn2.microsoft.com/en-us/library/ms187928.aspx

KH
[spoiler]Time is always against us[/spoiler]

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-09-17 : 01:59:59

quote:
Originally posted by sodeep

CAN SQL GURUS(PESO,MADHAVAN,VOLTER,KRISTEN) PROVIDE ME EXAMPLE OF CONVERT AND CAST FUNCTION CLEARLY WITH EXAMPLE

MADHAVAN???

Note that my name is Madhivanan

But If you want to use convert and cast over datetime column, I would advise you doing it in front end application until you post a query where you have problem

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources