Thanks.
I think it is easy to re-format the rtc datetime format into a mysql friendly string.
Would be great if you can insert this function into a component.
Search found 62 matches
- Fri Sep 11, 2026 12:21 am
- Forum: General
- Topic: rtc DD-MM-YY to mysql YYYY-MM-DD-HH-MM
- Replies: 3
- Views: 803
- Thu Sep 10, 2026 7:05 am
- Forum: General
- Topic: rtc DD-MM-YY to mysql YYYY-MM-DD-HH-MM
- Replies: 3
- Views: 803
rtc DD-MM-YY to mysql YYYY-MM-DD-HH-MM
Hi all
The mysql table requires the datetime format as: YYYY-MM-DD HH:MM:SS
Flowcode RTC component gives me a choice of:
0= DD:MM:YY
1= MM:DD:YY
Looks like I have to read and save the values separately as:
YY, MM, HR, MIN (set Secs as 00)
And reformat it to:
YYYY-MM-DD-HH-MM-00 ...
The mysql table requires the datetime format as: YYYY-MM-DD HH:MM:SS
Flowcode RTC component gives me a choice of:
0= DD:MM:YY
1= MM:DD:YY
Looks like I have to read and save the values separately as:
YY, MM, HR, MIN (set Secs as 00)
And reformat it to:
YYYY-MM-DD-HH-MM-00 ...
- Mon Nov 17, 2025 12:03 am
- Forum: General
- Topic: Haversine formula
- Replies: 8
- Views: 4946
Re: Haversine formula
Hi
All good. Thank you.
All good. Thank you.
- Sat Nov 15, 2025 5:57 am
- Forum: General
- Topic: Haversine formula
- Replies: 8
- Views: 4946
Re: Haversine formula
Hi Iain.
You are a good man.
I see the difference between the:
-------------------------------------------------------------------------
a = (sin (((lat_diff / 2) * sin (lat_diff / 2))) + cos (Lat1) * cos (Lat2) * (sin (lon_diff / 2) * sin (lon_diff / 2)))
And:
a = ((sin(dlat / 2) * sin(dlat / 2 ...
You are a good man.
I see the difference between the:
-------------------------------------------------------------------------
a = (sin (((lat_diff / 2) * sin (lat_diff / 2))) + cos (Lat1) * cos (Lat2) * (sin (lon_diff / 2) * sin (lon_diff / 2)))
And:
a = ((sin(dlat / 2) * sin(dlat / 2 ...
- Fri Nov 14, 2025 8:34 pm
- Forum: General
- Topic: Haversine formula
- Replies: 8
- Views: 4946
Re: Haversine formula
Hi again.
Haversine
Did not work for me.
a = sin² (Δlat / 2) + cos(lat1) × cos(lat2) × sin²(Δlong / 2)
Flowcode:
a = (sin (((lat_diff / 2) * sin (lat_diff / 2))) + cos (Lat1) * cos (Lat2) * (sin (lon_diff / 2) * sin (lon_diff / 2)))
c = 2 * atan2 (sqrt (a),sqrt (1 - a))
d = 6371.0 * c
Example1 ...
Haversine
Did not work for me.
a = sin² (Δlat / 2) + cos(lat1) × cos(lat2) × sin²(Δlong / 2)
Flowcode:
a = (sin (((lat_diff / 2) * sin (lat_diff / 2))) + cos (Lat1) * cos (Lat2) * (sin (lon_diff / 2) * sin (lon_diff / 2)))
c = 2 * atan2 (sqrt (a),sqrt (1 - a))
d = 6371.0 * c
Example1 ...
- Tue Nov 11, 2025 6:15 pm
- Forum: Feature Requests
- Topic: Component for GNSS / GPS Modules
- Replies: 5
- Views: 4161
Re: Component for GNSS / GPS Modules
I can only suggest to try to filter out the UTC time without even using the gps module.
If you use the string manipulations to get the 151227 out of ($GNRMC,151227.3997,) and convert it to local time, you can do the major part.
If you use the string manipulations to get the 151227 out of ($GNRMC,151227.3997,) and convert it to local time, you can do the major part.
- Tue Nov 11, 2025 6:12 pm
- Forum: General
- Topic: Haversine formula
- Replies: 8
- Views: 4946
Re: Haversine formula
Thank you guys for the help.
Will try to implement.
I thought I have to find the difference between the (for example) lat2-lat1 before the radian conversion.
Will try to implement.
I thought I have to find the difference between the (for example) lat2-lat1 before the radian conversion.
- Tue Nov 11, 2025 5:16 am
- Forum: General
- Topic: Haversine formula
- Replies: 8
- Views: 4946
Haversine formula
Hi
Wonder if anybody work with the gps distance calculation.
Any suggestions how to implement the Haversine formula?
Thanks.
Wonder if anybody work with the gps distance calculation.
Any suggestions how to implement the Haversine formula?
Thanks.
- Mon Nov 10, 2025 9:28 pm
- Forum: Feature Requests
- Topic: Component for GNSS / GPS Modules
- Replies: 5
- Views: 4161
Re: Component for GNSS / GPS Modules
HI. Only a time?
Why don't you use the cheap Neo 6x module?
Neo gives user a free software (u-centre).
Easy to test the module without the flowcode engine.
I do not think you need to use the flowcode component.
Neo module can receive the
$GNRMC,151227.3997,A,4723.5403567,N,00826.8867153,E,0.00000,81 ...
Why don't you use the cheap Neo 6x module?
Neo gives user a free software (u-centre).
Easy to test the module without the flowcode engine.
I do not think you need to use the flowcode component.
Neo module can receive the
$GNRMC,151227.3997,A,4723.5403567,N,00826.8867153,E,0.00000,81 ...
- Wed Nov 05, 2025 10:56 pm
- Forum: Feature Requests
- Topic: Component for GNSS / GPS Modules
- Replies: 5
- Views: 4161
Re: Component for GNSS / GPS Modules
Hi Stefan
I am working with Neo8N right now.
What is the benefit of GPS SMA (instead of high speed) ?
Does it have a high precision?
Thanks
I am working with Neo8N right now.
What is the benefit of GPS SMA (instead of high speed) ?
Does it have a high precision?
Thanks