Converting the value in specific date format into another specified format in u-sql script using u-sql operators and functions
up vote
0
down vote
favorite
lets say i have two variables a and b declared in the u-sql script as mentioned below. I have a scenario where i need to check the datetime value of column in a specific table is ranging in between two datetime values which are declared as variables below.
sample value of STARTDATETIME Column: 2018-11-06T14:06:15.0000000
I am able to convert time1 as it is straight forward and but i am not able to convert time2 which is in format ending with Z to StartDateTime Format .Can Someone help me on how i can do this Conversion Correctly in U-SQL Script
U-SQL Script:
DECLARE @time1 string = "11/11/2018 12:34:12 AM";
DECLARE @time2 string = "2018-11-11T06:46:52.3143918Z";
//sql query snippet in u-sql script
@testfile = SELECT [PRODUCT],[STARTDATETIME] from TABLEA WHERE [STARTDATETIME] BETWEEN Convert.ToDateTime(@time1) AND ?????
azure azure-data-factory u-sql edited Nov 14 at 8:41
AshokPeddakotla-MSFT
88017
asked Nov 11 at 12:10
Srujan K.N.
166
add a comment |
up vote
0
down vote
favorite
lets say i have two variables a and b declared in the u-sql script as mentioned below. I have a scenario where i need to check the datetime value of column in a specific table is ranging in between two datetime values which are declared as variables below.
sample value of STARTDATETIME Column: 2018-11-06T14:06:15.0000000
I am able to convert time1 as it is straight forward and but i am not able to convert time2 which is in format ending with Z to StartDateTime Format .Can Someone help me on how i can do this Conversion Correctly in U-SQL Script
U-SQL Script:
DECLARE @time1 string = "11/11/2018 12:34:12 AM";
DECLARE @time2 string = "2018-11-11T06:46:52.3143918Z";
//sql query snippet in u-sql script
@testfile = SELECT [PRODUCT],[STARTDATETIME] from TABLEA WHERE [STARTDATETIME] BETWEEN Convert.ToDateTime(@time1) AND ?????
edited Nov 14 at 8:41
AshokPeddakotla-MSFT
88017
asked Nov 11 at 12:10
Srujan K.N.
166
Try with DateTime.Parse(@time2) and see if it helps.
– AshokPeddakotla-MSFT
Nov 14 at 6:59
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
lets say i have two variables a and b declared in the u-sql script as mentioned below. I have a scenario where i need to check the datetime value of column in a specific table is ranging in between two datetime values which are declared as variables below.
sample value of STARTDATETIME Column: 2018-11-06T14:06:15.0000000
I am able to convert time1 as it is straight forward and but i am not able to convert time2 which is in format ending with Z to StartDateTime Format .Can Someone help me on how i can do this Conversion Correctly in U-SQL Script
U-SQL Script:
DECLARE @time1 string = "11/11/2018 12:34:12 AM";
DECLARE @time2 string = "2018-11-11T06:46:52.3143918Z";
//sql query snippet in u-sql script
@testfile = SELECT [PRODUCT],[STARTDATETIME] from TABLEA WHERE [STARTDATETIME] BETWEEN Convert.ToDateTime(@time1) AND ?????
edited Nov 14 at 8:41
AshokPeddakotla-MSFT
88017
asked Nov 11 at 12:10
Srujan K.N.
166
lets say i have two variables a and b declared in the u-sql script as mentioned below. I have a scenario where i need to check the datetime value of column in a specific table is ranging in between two datetime values which are declared as variables below.
sample value of STARTDATETIME Column: 2018-11-06T14:06:15.0000000
I am able to convert time1 as it is straight forward and but i am not able to convert time2 which is in format ending with Z to StartDateTime Format .Can Someone help me on how i can do this Conversion Correctly in U-SQL Script
U-SQL Script:
DECLARE @time1 string = "11/11/2018 12:34:12 AM";
DECLARE @time2 string = "2018-11-11T06:46:52.3143918Z";
//sql query snippet in u-sql script
@testfile = SELECT [PRODUCT],[STARTDATETIME] from TABLEA WHERE [STARTDATETIME] BETWEEN Convert.ToDateTime(@time1) AND ?????
edited Nov 14 at 8:41
AshokPeddakotla-MSFT
88017
asked Nov 11 at 12:10
Srujan K.N.
166
edited Nov 14 at 8:41
AshokPeddakotla-MSFT
88017
asked Nov 11 at 12:10
Srujan K.N.
166
edited Nov 14 at 8:41
AshokPeddakotla-MSFT
88017
edited Nov 14 at 8:41
AshokPeddakotla-MSFT
88017
edited Nov 14 at 8:41
AshokPeddakotla-MSFT
88017
88017
asked Nov 11 at 12:10
Srujan K.N.
166
asked Nov 11 at 12:10
Srujan K.N.
166
asked Nov 11 at 12:10
Srujan K.N.
166
166
Try with DateTime.Parse(@time2) and see if it helps.
– AshokPeddakotla-MSFT
Nov 14 at 6:59
add a comment |
Try with DateTime.Parse(@time2) and see if it helps.
– AshokPeddakotla-MSFT
Nov 14 at 6:59
Try with DateTime.Parse(@time2) and see if it helps.
– AshokPeddakotla-MSFT
Nov 14 at 6:59
Try with DateTime.Parse(@time2) and see if it helps.
– AshokPeddakotla-MSFT
Nov 14 at 6:59
add a comment |
1 Answer
1
active
oldest
votes
up vote
0
down vote
I'd use the DateTime.ParseExact
@testfile = SELECT [PRODUCT],[STARTDATETIME] from TABLEA WHERE [STARTDATETIME] BETWEEN Convert.ToDateTime(@time1) AND DateTime.ParseExact(@time2, "yyyy-MM-ddTHH:mm:ss.fffffffZ", NULL);
answered Nov 12 at 21:18
Saul Cruz
32729
add a comment |
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
0
down vote
I'd use the DateTime.ParseExact
@testfile = SELECT [PRODUCT],[STARTDATETIME] from TABLEA WHERE [STARTDATETIME] BETWEEN Convert.ToDateTime(@time1) AND DateTime.ParseExact(@time2, "yyyy-MM-ddTHH:mm:ss.fffffffZ", NULL);
answered Nov 12 at 21:18
Saul Cruz
32729
add a comment |
up vote
0
down vote
I'd use the DateTime.ParseExact
@testfile = SELECT [PRODUCT],[STARTDATETIME] from TABLEA WHERE [STARTDATETIME] BETWEEN Convert.ToDateTime(@time1) AND DateTime.ParseExact(@time2, "yyyy-MM-ddTHH:mm:ss.fffffffZ", NULL);
answered Nov 12 at 21:18
Saul Cruz
32729
add a comment |
up vote
0
down vote
up vote
0
down vote
I'd use the DateTime.ParseExact
@testfile = SELECT [PRODUCT],[STARTDATETIME] from TABLEA WHERE [STARTDATETIME] BETWEEN Convert.ToDateTime(@time1) AND DateTime.ParseExact(@time2, "yyyy-MM-ddTHH:mm:ss.fffffffZ", NULL);
answered Nov 12 at 21:18
Saul Cruz
32729
I'd use the DateTime.ParseExact
@testfile = SELECT [PRODUCT],[STARTDATETIME] from TABLEA WHERE [STARTDATETIME] BETWEEN Convert.ToDateTime(@time1) AND DateTime.ParseExact(@time2, "yyyy-MM-ddTHH:mm:ss.fffffffZ", NULL);
answered Nov 12 at 21:18
Saul Cruz
32729
answered Nov 12 at 21:18
Saul Cruz
32729
answered Nov 12 at 21:18
Saul Cruz
32729
answered Nov 12 at 21:18
Saul Cruz
32729
32729
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53248599%2fconverting-the-value-in-specific-date-format-into-another-specified-format-in-u%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Try with DateTime.Parse(@time2) and see if it helps.
– AshokPeddakotla-MSFT
Nov 14 at 6:59