Need current time in hh:mm[AM/PM] format

• rajesh466

  SSC Veteran

  Points: 221

  More actions

  June 11, 2008 at 12:57 am

  #186672

  Hi ,

  I am a newbie to SQL server . I need current time in hh:mm[AM/PM] (say 7:50PM ) format using getdate function.

  I tried substring(convert(varchar,getdate()),13,7) but i need more simpler function than this. 🙂

• shrikant-279400

  SSCommitted

  Points: 1651

  More actions

  June 11, 2008 at 1:06 am

  #827085

  select right(convert(varchar,getdate(),0),7) as Format_Time

  Regards
  Shrikant Kulkarni