Convert Date

Question

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Dave Ballantyne SSC-Dedicated Points: 33667 More actions · Answer 1

Break it down to its component parts

ie

Start with

select convert(varchar(255), D_Date, 120)

then

Select convert(varchar(10), D_Date, 120)

then

Select left((convert(varchar(10), D_Date, 120)), 13)

Which is slightly bizzare , taking the left 13 characters of a varchar(10).

Use Bol (Books on line)as your primary resource the functions are all well documented

Clear Sky SQL
My Blog[/url]

t.hitendra SSCommitted Points: 1620 More actions · Answer 2

Hi,

Left is an inbuilt function that returns left part a string starting from 0 and upto the length specified (13 in your case).

Replace is another inbuilt string function that will replace a subset of string with another say ',' with ';'.

and convert function for datetime is well documented which returns datetime in various formats as specified by the code (120 in your case

which return 'yyyy-mm-dd hh:MM:ss' format) .

You can also refer Books Online for details.

Hope that helps

pitso.maceke Default port Points: 1467 More actions · Answer 3

Hi

Thank you very much, can you send me one useful link where I can able to download some T-SQL ebook?

Kind Regards

Pitso

Dave Ballantyne SSC-Dedicated Points: 33667 More actions · Answer 4

You could try this...

Clear Sky SQL
My Blog[/url]

pitso.maceke Default port Points: 1467 More actions · Answer 5

Default port

Points: 1467

July 7, 2009 at 5:34 am

Any suggestion on specific ebook to use

pitso.maceke Default port Points: 1467 More actions · Answer 6

Default port

Points: 1467

July 7, 2009 at 6:21 am

Hi,

This looks helpful. Thanks alot.

cool: