Date Time combine save into SQL

(0) Share

Report

Posted on by Big_S

494

Hi Guys,

Do you know how to combine datepicker and time to save into the database as one?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (2)

Verified answer

seadude 1,855 on at

Like (0)

Report
Hi @Big_S . It depends on what data type the SQL field is. String? Numeric? Datetime? Datetime2?
Try a combination of the Concatenate and Text functions. Also check out the DateTimeValue function.
Something like:
Text( Concatenate( Text(datepicker.SelectedDate), ddHour.Selected.Value, ":", ddMinute.Selected.Value ), "mm/dd/yyyy hh:mm:ss" )
Also, we have a lot of fun with Time in the forums here. Search the forum for "Time after time" or "Time to party" for some really good examples of Time functions.
Good luck!

Was this reply helpful? Yes No
Big_S 494 on at

Like (0)

Report

Hi @seadude
This is my table design im using time as data type how to apply your formula on this? 🙂

Was this reply helpful? Yes No
Verified answer

seadude 1,855 on at

Like (0)

Report

Hi @Big_S ,

Aha. This changes things a bit. It looks like you have one DataCard/Group with three values (date, hour, minute)(?).
- Use Concatenate Function to combine Hour/Min dropdowns along with the ":"
- Use Text Function to convert the combined text to time(7) format
- Then patch this value to each Time column accordingly
- You might also experiment with the PowerApps Time Function
- I don't think there would be anything special required for Patching the Datepicker date.

You might also consider combining the date and time columns into a single:
I dont' directly use time(7) in SQL but rather datetime(2) then parse things on the display/analysis end to peel out times as needed. I also like datetimeoffset. It basically holds users local time, UTC, and timezone all in a single column.

Again, might be 1/2 dozen of one 6 of the other as you may have to parse these on the display/analysis end (data visualization) to compare certain values.
Good luck!

Was this reply helpful? Yes No
Big_S 494 on at

Like (1)

Report

THANK YOU SO MUCH! @seadude 🙂

Was this reply helpful? Yes No