How to use Datetime offset in U-SQL?

Question

Hello All,

i am trying to get current system time as
DECLARE @now Datetime= DateTime.Now();

Here I am getting PST time but i want to display EST time.
So how can I achieve this?

Accepted Answer

@Subhodeep Chakraborty Thanks for using Microsoft Q&A !!

You can use Function like below to convert local DateTime to specific timezone -

DECLARE @func Func = (d) => {  
                                        TimeZoneInfo cstZone = TimeZoneInfo.FindSystemTimeZoneById("Eastern Standard Time");  
                                        DateTime.SpecifyKind(d, DateTimeKind.Local);  
                                        DateTime estTime = TimeZoneInfo.ConvertTime(d, cstZone);  
return estTime;                                                                         
};  
  
@data =   
    SELECT data FROM   
( VALUES   
   (DateTime.UtcNow)) AS T(data);  
  
  
@result =  
    SELECT @func(data).ToString("dd-MM-yyyyThh:mm:ss") AS data FROM @data;  
  
OUTPUT @result  
TO "datafolder/data.csv"    
USING Outputters.Tsv();

Result:

----------

Please do not forget to "Accept the answer" wherever the information provided helps you to help others in the community.

Answer

Hi @Saurabh Sharma ,

This Works sweet. Thank you.
Also Can you please tell me, How I can Append this converted EST Datetime in the output file name?

Share via

How to use Datetime offset in U-SQL?

1 additional answer

Your answer