[RESOLVED] Need Help Urgently
Hi, Could anyone help me on how to format a datagrid column which is a datetime to display only time format like 'HH:mm". I try with 'formatdatetime(Mydataset.Item(1), Dateformat.ShortTime)' but it does not work, it still display date not time. I could not format it at the tablestyle because it does not support format. I search msdn but the method is incomplete I couldn't implement it. So if any body could help. Thanks
Re: [RESOLVED] Need Help Urgently
Hi,
select convert(varchar(5),getdate(),108) gives you what you want
Pete