untagged – How to get date from my Garmin ForeRunner 225 or Garmin Connect?

I just switched to a Garmin running watch (ForeRunner 225), and am missing some very basic stuff.

As far as I can see, Garmin Connect (online), only shows a pokey little map of my run (actual size):

enter image description here

I would expect to be able to a larger view map, hopefully full screen – am I missing something? I am aware of this, but it does not work for me.

Last time I use a Garmin was over ten years ago when I had a ForeRunner 301 and they had a different app. IIRC, that had a map, it also had histograms below. You could click on either and it would show the other. Click on a point of your run on the map & it would show your data at that point, such as time heart rate, distance, etc. Click on some data, say a point with high heartrate, and it would show you it on the map.

I can’t believe that they have regressed in their software capability, so maybe I am just too dumb to own a Garmin?

Can I use Garmin Connect to view data in the way described? Or is there a Windows app to get the data from the watch?

If not, which would surprise me, can I export the data, either from the web site or the watch? I am a programmer and can code my own app, if need be. I did find a way to export data for a run from the website as CSV, but that was only a summary – it did not show individual data readings for time/GPS/heartrate, etc.

I am probably overlooking something very basic, but I just can’t find it & google is not my friend today.

8 – Change sort order of SOURCE STRING list at User interface translation page to alphabetical instead of date created

At the User interface translation page (/admin/config/regional/translate) the SOURCE STRING list seems to be ordered by creation date/time (it is for strings I add). Is there a “good” (non-hackish) way to change the order to alphabetical? I haven’t found anything in the interface.

For those who wonder why I want this, I use interface translation in an unconventional way. Instead of putting literals like t("Choose your options") in my code, I put in a key like t(‘rsc-string-choose-options’) (rsc is the name of my custom module). Then as the translation, I put in “Choose your options”. This allows me to use “keys” for all strings (literals, messages, titles, email body text, etc.). It’s easy to look up my keys because they all begin with ‘rsc-‘ followed by ‘string’, ‘message’, ’email’, etc. depending on usage. Doing this provide a nice interface for editors to go in and change the text of the strings, since they can look them up either by translation or by key. I also wrote a nice utility that allows me to add, remove, rename, and test keys (i.e. translation strings). It’s working very well, but it would make review much easier if the source strings were alphabetical.

How does github determine the first commit date of a file?

I’m not very familiar with github and it’s web interface except how to do basic operations (view the uploaded files, download as zip, fork project)

Recently Microsoft open sourced the GWBASIC assembly source code, and all the files in the project show that they were committed 38 years ago except README.md which was added 5 days ago

enter image description here

I always thought the commit date was based on when the file as first uploaded to github, but doesn’t seem to be the case. What is happening here, or did github actually exist in 1983?

Microsoft announcement

sql server – conversion failed when converting date and/or time from character string c#

Action Method:

PayTns std = new PayTns();
std.C_Group = fc(“C_Group”);
std.Date = Convert.ToDateTime(fc(“Date”));
std.C_Name = fc(“C_Name”);
std.D_Group = fc(“D_Group”);
std.D_Name = fc(“D_Name”);
std.Amount = Convert.ToInt32(fc(“Amount”));
std.Remark = fc(“Remark”);
if (D_flag == “true”)
std.D_Flag = true;
std.D_Flag = false;
std.T_No = Convert.ToInt32(fc(“T_No”));
TempData(“msg”) = “Data Inserted”;

Data Connection:

SqlCommand com = new SqlCommand(“Master_PayTns_Add”, con);
com.CommandType = CommandType.StoredProcedure;
com.Parameters.AddWithValue(“@Date”, ie.Date);
//com.Parameters.AddWithValue(“@A_GRef”, ie.A_GRef );
com.Parameters.AddWithValue(“@C_Group”, ie.C_Group);
com.Parameters.AddWithValue(“@C_Name”, ie.C_Name);
com.Parameters.AddWithValue(“@D_Group”, ie.D_Group);
com.Parameters.AddWithValue(“@D_Name”, ie.C_Name);
com.Parameters.AddWithValue(“@Amount”, ie.Amount);
com.Parameters.AddWithValue(“@Remarks”, ie.Remark);
com.Parameters.AddWithValue(“@D_FLag”, Convert.ToBoolean(ie.D_Flag));
com.Parameters.AddWithValue(“@T_No”, ie.T_No);


python3 – parse function returning wrong date from the string in python 3

I am trying to extract date from the string.

if the string has exact date, then parse funtion will return correct date

from dateutil.parser import parse
ExDate = parse("My Birthday is on 28/05/2020", fuzzy=True) #Any format is working here

#The output will be
2020-05-28 00:00:00

#Now i following will give wrong result:
ExDate = parse("i am 28 years old", fuzzy=True)

#The output will be:
2020-05-28 00:00:00  #Which is Wrong

What i want is, if it finds exact date in a string then only it has to return the date, else it has to return null or empty string.

Any help would be appriciated

date and time – Is TimeZoneOffset broken?

I just realized that code like this:


does not return a timezone value anymore. I am quite confident that this has worked up to a few days as I run test-code which contains that snippet (almost) every night.

Similar code is part of the documentation and has been suggested on this site, e.g.:

TimeZoneOffset(Entity("City", {"Paris", "IleDeFrance", "France"}))
TimeZoneOffset(GeoPosition(Entity("ZIPCode", "94402")("Coordinates")))

and those examples also don’t work for me anymore. Interesting thing is that this is independent of the mathematica-version I use and happens on at least three different machines that I have access to. Does anyone else see these problems except for me? I would consider this a bug…

Sorting mysql resultset based on date

Sorting mysql resultset based on date

I got 2 columns, “firstName” and “myDate”
“myDate” stores date in this format: “2020-11-29” (YYYY-mm-dd format)
Its a varchar column

There could be multiple records for each “firstName”, the date will differ.
(‘jeet’, ‘2020-05-30’),
(‘jeet’, ‘2020-05-31’),
(‘Lucky’, ‘2020-05-31’),
(‘Lucky’, ‘2020-06-01’),

I am trying to select all “firstName”, but only 1 record for each name, the one with the smallest date.

select * from table order by myDate asc group by firstName

Problem is “myDate” is a varchar column, and I am not sure if results will be sorted correctly all the time.
So I was hoping to convert myDate input to a numerical format like unix timestamp, and then sort it.
How can I do this in the query?


postgresql – Statistics collector: query in a date range and other questions

I want to use the Statistics Collector (https://www.postgresql.org/docs/9.6/monitoring-stats.html) in order to obtain the total database times during a certain period.

Once enabled, I can successfully execute a query such as:

    SELECT SUM(total_time) ms
    FROM pg_stat_statements, pg_database
    WHERE pg_stat_statements.dbid = pg_database.oid and pg_database.datname='MyDatabase';

However, the problem is that this returns all the milliseconds in queries since the last call to pg_stat_statements_reset(). At least I have not found a way to query the milliseconds within a specific time range, which is what I would like to obtain. Is there any way to do this? If not, can I at least know when was the last time pg_stat_statements_reset() was executed (I don’t really know, but I guess this must be stored somewhere)?

If I need to obtain the milliseconds spent by month, is there any recommended workflow to do this? I was thinking of defining a trigger, but probably there is a standard/recommended way to do it.

Finally, I assume the query returns the total time elapsed in the queries: is it possible to divide this time between CPU time and I/O time?

Thank you very much!

date – Agrupar dados por hora do dia no google data studio

Estou estruturando um relatorio no google dsta studio e tenho dados de quantidade de cargas por hora e minuto do dia. Queria agrupar estes dados por hora para gerar um gráfico das quantidades de cargas por hora e não por hora e minuto.
A fonte dos dados é uma google planilhas.
Já tentei utilizar o recurso da formatação por tipo data hora mas não funcionou