reply fast as possible?

Question

select convert(smalldatetime'14/05/2012 20:20:00'103) output is 2012-05-14 20:20:00 But i need date in terms of 15/04/2012 20:20:00Because i need to compare 15/04/2012 20:20:00 with column of type smalldatetime column in a table please suggest........ thanks in advance

brit arun · Answer

HI Use this Select convert(varchargetdate()101)

Kunal Vaishya · Answer

Dear try as per requirment Select Convert(VarcharGetdate()101) - MM/dd/yyyy Select Convert(VarcharGetdate()103) - dd/MM/yyyy For MM/dd/yyyy Select Convert(VarcharGetdate()1) dd/MM/yyyy Select Convert(VarcharGetdate()3) hh:mm:ss Select Convert(VarcharGetdate()2)

Kunal Vaishya · Answer

try Select Convert(VarcharGetdate()103)

Santhosh K S · Answer

i'm getting like this sir2012-05-05 20:20:00 i need 05/05/2012 like this only....Please

brit arun · Answer

Hi Use the below code select convert(smalldatetime' 14/05/2012 20:20:00'101) it will return 15/04/2012 20:20:00