By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
DECLARE @VitalReadingDate Date = '2024-01-11',
@VitalReadingTime Time = '10:31:00';
SELECT @VitalReadingDate As DateValue
, @VitalReadingTime As TimeValue
, DATEADD(dd,DATEDIFF(dd,'1900',@VitalReadingDate),CONVERT(DATETIME2, @VitalReadingTime)) As LocalDateTime
, DATEADD(dd,DATEDIFF(dd,'1900',@VitalReadingDate),CONVERT(DATETIME2, @VitalReadingTime))
AT TIME ZONE 'Central Asia Standard Time'
AT TIME ZONE 'UTC' As UTC;
| DateValue | TimeValue | LocalDateTime | UTC |
|---|---|---|---|
| 2024-01-11 | 10:31:00.0000000 | 2024-01-11 10:31:00.0000000 | 2024-01-11 04:31:00.0000000 +00:00 |