convert a given year into number format

[teddysnow12]

Hi,

I have a year field like rptg_yyyymm.
I need to convert it into number format in SQL.
Can anyone give me the syntax for this in SQL.
the number should like this,
for example if the year is 2008-10
it should look like 200810



Thanks!

 

[MCuthill]

TeddySnow,

Google returned the following when searching for "Formatting A Date in SQL": [URL unfurl="true"]http://weblogs.sqlteam.com/...[/url]

Hope this helps!

Mike
---------------------------------------------------------------
"To be alive is to revel in the moments, in the sunrise and the sunset, in the sudden and brief episodes of love and adventure,
in the hours of companionship. It is, most of all, to never be paralyzed by your fears of a future that no one can foretell."

 

[pomster]

http://www.sql-server-helper.com/tips/date-formats.aspx

regards,


David

CRXIR2 with CRXIR2 server and SQL 2005
CR2008 with CR2008V1 Server and SQL 2005

 

[IanWaterman]

Should be

cast(replace(yourfield, '-', '') as int) as datenumber

Ian

 

[SkipVought]

I have a year field like rptg_yyyymm

If anything, a programmer ought to be precise. It is the nature of our profession.

So do you have a DATE field, formatted to display yyyy-mm or do you have a STRING field, structured as yyyy-mm? BIG difference!


Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[teddysnow12]

Thank you guys for your valuable answers.
helped me a lot.