Need to get the date part from a column and Convert the time zone from UTC to CST time zone

Question

Need to get the date part from column Start_DateTime (varchar data type) which is having data like '06/04/19 10:44 AM CDT' , '06/10/19 11:56 AM EDT' and need to convert the time zone to CST time zone

I have a user defined function dbo.fn_UTCtoCST that will convert the time zone but am trying to combine all this in a select query to get the desired result

SELECT 
            Start_DateTime
           ,Inspector
           ,Status
           ,Distance
           ,Location
from XYZ

Never store timestamp values in a `varchar` column. The problem you have now, is a direct result of using the wrong data type — a_horse_with_no_name, Jun 11 '19 at 04:04
You may refer to this question: https://stackoverflow.com/questions/207190/sql-server-string-to-date-conversion — Flavio Francisco, Jun 11 '19 at 07:53

score 0 · Answer 1 · edited Jun 11 '19 at 04:04

0

If your function is scalar value function(returning one value) then this might will work for you.

select * 
from A 
  cross apply dbo.fn_UTCtoCST(date)  cstdate.

edited Jun 11 '19 at 04:04

a_horse_with_no_name

497,550
91
775
843

answered Jun 11 '19 at 03:50

Mak

1,020
6
19

Why the apply? If the function is a scalar function you can use it directly in the SELECT list: `select dbo.fn_UTCtoCST(date) from a` – a_horse_with_no_name Jun 11 '19 at 04:05
I meant to say function should return one row(one value). – Mak Jun 11 '19 at 04:08
There is a huge difference between "one row with one column" and a "single (scalar) value" – a_horse_with_no_name Jun 11 '19 at 04:09
One row one column that means single value i guess. https://www.c-sharpcorner.com/UploadFile/898089/how-to-create-scalar-value-function-in-sql-server-2012/ – Mak Jun 11 '19 at 04:27

Need to get the date part from a column and Convert the time zone from UTC to CST time zone

1 Answers1