# Date Time Join for SQL Query

**URL:** <https://discourse.nodered.org/t/date-time-join-for-sql-query/27768>\
**Category:** General\
**Created:** [4 June 2020 13:30 UTC](https://discourse.nodered.org/t/date-time-join-for-sql-query/27768 "2020-06-04T13:30:36Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![farcry](https://avatars.discourse-cdn.com/v4/letter/f/9de053/32.png) [@farcry](https://discourse.nodered.org/u/farcry)\
**Post date:** [4 June 2020 13:30 UTC](https://discourse.nodered.org/t/date-time-join-for-sql-query/27768/1 "2020-06-04T13:30:36Z")

</div>

Hello.  
I'm trying to combine Date & Time using using ui\_text\_input and ui\_date\_picker.  
What I'm trying to do is:

- Input Date and Time to get string like 2020-06-03 12:15:30.000
- I wold like to use this string to QUERY SQL DataBase.  
I tried this:

if(msg.topic == 'time\_start'){  
var TimeStart = msg.payload;  
}  
if(msg.topic == 'date\_start'){  
var DateStart = msg.payload;  
}  
if(msg.topic == 'time\_end'){  
var TimeEnd = msg.payload;  
}  
if(msg.topic == 'date\_end'){  
var DateEnd = msg.payload;  
}

msg.topic = "Ts: " + TimeStart + " Ds: " + DateStart + " Te: " + TimeEnd + " De: " + DateEnd;

return msg;

But the problem is, that each ui\_text\_input and ui\_date\_picker fires an event when it is changed.  
Thanks.  
BR, Andrej.

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [4 June 2020 13:43 UTC](https://discourse.nodered.org/t/date-time-join-for-sql-query/27768/2 "2020-06-04T13:43:48Z")

</div>

You will need to join those two together into one message, which you can do using the Join node. However, how will you know when to run the query?

---

<div class="post-metadata">

**Author:** ![farcry](https://avatars.discourse-cdn.com/v4/letter/f/9de053/32.png) [@farcry](https://discourse.nodered.org/u/farcry)\
**Post date:** [4 June 2020 16:00 UTC](https://discourse.nodered.org/t/date-time-join-for-sql-query/27768/3 "2020-06-04T16:00:24Z")

</div>

Hello.  
I have solved it using flow.get (Button triggered) / flow.set (UI triggered)

var TimeStart = flow.get("TimeStartSet")||0;  
var DateStart = flow.get("DateStartSet")||0;  
var TimeEnd = flow.get("TimeEndSet")||0;  
var DateEnd = flow.get("DateEndSet")||0;

var DateTimeStart = DateStart + " " + TimeStart;  
var DateTimeEnd = DateEnd + " " + TimeEnd;

var dbQuery = "SELECT \* FROM Senzorji WHERE [DateTime] \>= '" + DateTimeStart + "' AND [DateTime] \<= '" + DateTimeEnd + "'"  
msg.payload = dbQuery;  
return msg;

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [3 August 2020 16:00 UTC](https://discourse.nodered.org/t/date-time-join-for-sql-query/27768/4 "2020-08-03T16:00:26Z")

</div>

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.