----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: Sam786786 Message 2 in Discussion Hi Manju, you can use code 101 insted of 1 in conversion function, so new date will be like replace(convert(varchar, REG.TAX_PRORATION_DATE, 101), '/', '') as PURCHASE_DATE, one more thig why r u using replace function? u can use just only convert(varchar, REG.TAX_PRORATION_DATE, 101). Hopes it will help Zaidi From: "Manjusha" <[EMAIL PROTECTED]> Reply-To: "BDOTNET" <[email protected]> To: [email protected] CC: [EMAIL PROTECTED] Subject: Date Format in Stored procedure Date: Thu, 21 Dec 2006 13:45:36 -0800 <META content="Microsoft SafeHTML" name=Generator> <STYLE> ThmFgColumnHeader, A.FrameLink, A.HeaderLink, A.FooterLink, A.LgtCmd, A.MSNLink {color:#FFFFFF;} ThmFgTitleLightBk {color:#FF6600;} ThmFgSmallLight {color:#ff0000;} ThmFgNavLink, A.NavLink, A.ChildLink:hover {color:#666699;} ThmFgInactiveText, A.SystemLink {color:#666666;} ThmFgFrameTitle {color:#FFFFCC;} ThmFgTitleDarkBk, A.NavLink:hover, A.TitleLink {color:#CC6600;} ThmFgMiscText, A.Cat, A.SubCat {color:#336699;} ThmFgCommand, A.Command, A.LargeCommand, A.MsgLink {color:#003366;} ThmFgHeader {color:#333333;} ThmFgStandard, A.SystemLink:hover, A.SubLink, A.ChildLink, A.StdLink, SELECT.Standard {color:#000000;} ThmFgDivider {color:#CCCCCC;} ThmBgStandard {background-color:#FFFFFF;} ThmBgUnknown1 {background-color:#FF6600;} ThmBgFraming {background-color:#666699;} ThmBgUnknown2 {background-color:#666666;} ThmBgHighlightDark {background-color:#FFFFCC;} ThmBgHighlightLight, #idToolbar, #tbContents {background-color:#FFFFE8;} ThmBgTitleDarkBk {background-color:#F1F1F1;} ThmBgAlternate {background-color:#ECF1F6;} ThmBgUnknown3 {background-color:#CCCCFF;} ThmBgDivider {background-color:#CCCCCC;} ThmBgHeader {background-color:#9999CC;} ThmBgLinks {background-color:#8696C9;} ThmBgSharkBar {background-color:#8696C9;} ThmBgGlobalNick {background-color:#9394A9;} calfgndcolor {color:#E00505;} calbgndcolor {color:#E00505;} </STYLE> New Message on BDOTNET Date Format in Stored procedure Reply Reply to Sender Recommend Message 1 in Discussion From: Manjusha Guyz!!, My current stored procedure code is as follows: replace(convert(varchar, REG.TAX_PRORATION_DATE, 1), '/', '') as PURCHASE_DATE, It pulls out the data in mm/dd/yy format. I need format to be mm/dd/yyyy. Can any one suggest me the appropriate solution for this. Thanks. Manju Catch all the cricketing action right here. Live score, match reports, photos et al. View other groups in this category. To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. Need help? If you've forgotten your password, please go to Passport Member Services. For other questions or feedback, go to our Contact Us page. If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. Remove my e-mail address from BDOTNET. View Athletes Collections with Live Search ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/bdotnet/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
