Top What's New Develop Technic Contact
ƒƒ“ƒ|ƒCƒ“ƒg

[MS SQL Server]

MidŠΦ”‚Μ‚ζ‚€‚ΙŽw’θ•ΆŽš—ρ‚π•Τ‚·FSUBSTRING

[ŠT—v]

SQL Server‚ΕMidŠΦ”‚Μ‚ζ‚€‚ΙŽw’θ•ΆŽš—ρ‚π•Τ‚·•ϋ–@‚Ε‚·B

[\•Ά]

SUBSTRING(•ΆŽš—ρ,ŠJŽnˆΚ’u,•ΆŽš”)

[ƒTƒ“ƒvƒ‹]

‰Ί‹L‚ΜƒTƒ“ƒvƒ‹‚ł́uZŠ˜^vƒe[ƒuƒ‹‚©‚ηu–Ό‘Ov‚Ɓu“o˜^“ϊ•tvƒtƒB[ƒ‹ƒh‚Μ“ͺ‚S•ΆŽš•ͺi—αF20020715‚Ε‚ ‚κ‚΁h2002hj‚πAŒ‹‰Κ‚Ζ‚΅‚Δ•Τ‚΅‚ά‚·B

SELECT –Ό‘O, SUBSTRING(“o˜^“ϊ•t,1,4) AS YEAR FROM ZŠ˜^

Œ‹‰Κ
---------------------
—ι–Ψ   2001
“c’†   2002
ˆΐ“c   2002