The Dateadd function problem?????

[Alexraj]

Dateadd when I used this function to add hours to time
if I add 2 hours to time 11 pm I get time with date
like 31/12/1899 01:21:00 am
how can i get the time only
thank you

[inspectelement]

Are you using Date part or Syntax?

[inspectelement]

DECLARE @datetime2 datetime2 = '13:10:10.1111111';
UNION ALL
SELECT 'hour',DATEADD(hour,1,@datetime2)
UNION ALL
SELECT 'minute',DATEADD(minute,1,@datetime2)
UNION ALL
SELECT 'second',DATEADD(second,1,@datetime2)
UNION ALL
SELECT 'millisecond',DATEADD(millisecond,1,@datetime2)
UNION ALL
SELECT 'microsecond',DATEADD(microsecond,1,@datetime2)
UNION ALL
SELECT 'nanosecond',DATEADD(nanosecond,1,@datetime2);

[inspectelement]

Figure this will work? Just the times, not the date, month, etc.

[Alexraj]

Thank sir my code like
Txtnow.text=for mat(time,"hh:mm am|pm)
Txtadd.text=dat eadd("h",2,Txtn ow.text)
When the Txtnow.text=11: 00
The value of Txtadd is old date like that in my question and time
Thank u again

[inspectelement]

Is it all good? No more problems?