Use of European Netgear Nighthawk M1 in the US

I’m planning on buying a Netgear Nighthawk M1 for use in the EU but also on holiday in the US.

Now I know there are different frequencies and bands in the US that make it so EU devices cannot work properly or at all in the US.

I have read that some 3G might work however. According to the Dutch Netgear website the device supports the following frequencies:

  • LTE/4G: 700/800/900/1800/2100/2300/2500/2600 MHz
  • 3G: 850/900/1900/2100 MHz

Could any of these frequencies work in the US? I was planning on going for a T-Mobile tourist plan.

This is the Dutch Netgear product page: https://www.netgear.nl/home/products/mobile-broadband/mobilerouters/M1.aspx

Visa regaring travelling European country

I am an Indian. I am doing my research in the USA(Saint Louis). I will be going back to India and then will be going to Europe for academic conference( Spain 20th to 25th of May, then Hungary 26th May to 1st June and then Italy from 2nd June to 7th of June) from India this summer. I am completely blind after calling the Spain consulate here in Saint Louis. My concern is for the European short term visa So,

  1. Can I apply for a visa from the USA although I will leaving for Spain from India?
  2. Do I have to apply for a student visa there or tourist visa as the available dates in Spanish consulate for a tourist visa is 7th of May(that is impossible for me) and for student visa there are many dates?
  3. Then will applying for the visa in one consulate be enough as this will be Schengen visa as per my knowledge?

Correctly determine daylight-saving time in Central European Time?

The following constellation:
Our applications pass date&time around (in the most horrible way possible).
We want to simplify this. Instead of a culture-specific string like ‘31.12.2019’, we’re now passing an ecma-timestamp (the number of milliseconds between the point in time in UTC and 1970-01-01 00:00:00 UTC that is).

Now an additional complication.
Our pitiful application historically has saved all datetime values in the database as local time WITH DAYLIGHT-SAVING (central european summer or winter time, depending on the date ****aargh****) instead of UTC.

Now, central european summer time (CEST) is UTC+2, while central european winter time (CET) is UTC+1.

For the adjustment between summer and winter time, the following rules are applied:

  • the change from winter time to summer time is on the last sunday of March
    On the last Sunday morning of March, the clocks will be put forward from 02:00 to 03:00. (one ‘loses’ an hour)

  • the change from summer time to winter time is on the last sunday of October:
    On the last Sunday morning of October, the clocks will be put backward from 03:00 to 02:00 (one wins an hour).

As you might realize from looking at the definition, the change from summer to winter time presents a discontinuity range, in which a given local-time value can be both summer or winter time… (but not the change from winter to summer time)

Now, I have written the below functions to convert local/utc-time into an ECMA-timestamp, and you can specify if the input datetime is UTC or localtime.

I haven’t had the time to test it all too extensively, but I’d like to collect a second opinon on how to handle the times between 02 and 03 o’clock at the last Sunday of October…

  • Would you handle the conversion the same ? (appart from the fact that ideally, the conversion would be avoided / data changed to UTC)
  • Do you spot any error ?
  • Thoughts on what best to do between 02 and 03 …

Code:

PRINT 'Begin Executing "01_fn_dtLastSundayInMonth.sql"'   GO     IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[fn_dtLastSundayInMonth]') AND type in (N'FN', N'IF', N'TF', N'FS', N'FT')) BEGIN     EXECUTE(N'CREATE FUNCTION [dbo].[fn_dtLastSundayInMonth]() RETURNS int BEGIN RETURN 0 END ') END  GO     /* -- This is for testing SET DATEFIRST 3; -- Monday  WITH CTE AS (      SELECT 1 AS i, CAST('20190101' AS datetime) AS mydate       UNION ALL       SELECT i+1 AS i, DATEADD(month, 1, CTE.mydate) AS mydate      FROM CTE WHERE i < 100  )  SELECT -666 AS i, dbo.fn_dtLastSundayInMonth('17530101') AS lastSundayInMonth, dbo.fn_dtLastSundayInMonth('17530101') AS Control   UNION ALL   SELECT -666 AS i, dbo.fn_dtLastSundayInMonth('99991231') AS lastSundayInMonth, dbo.fn_dtLastSundayInMonth('99991231') AS Control   UNION ALL   SELECT       mydate      ,dbo.fn_dtLastSundayInMonth(mydate) AS lastSundayInMonth      ,dbo.fn_dtLastSundayInMonth(mydate) AS lastSundayInMonth      ,DATEADD(day,DATEDIFF(day,'19000107', DATEADD(MONTH, DATEDIFF(MONTH, 0, mydate, 30))/7*7,'19000107') AS Control  FROM CTE   */   -- ===================================================================== -- Author:        Stefan Steiger -- Create date:   01.03.2019 -- Last modified: 01.03.2019 -- Description:   Return Datum von letztem Sonntag im Monat  --                mit gleichem Jahr und Monat wie @in_DateTime -- ===================================================================== ALTER FUNCTION [dbo].[fn_dtLastSundayInMonth](@in_DateTime datetime ) RETURNS DateTime AS BEGIN     -- Abrunden des Eingabedatums auf 00:00:00 Uhr     DECLARE @dtReturnValue AS DateTime       -- 26.12.9999   SO     IF @in_DateTime >= CAST('99991201' AS datetime)          RETURN CAST('99991226' AS datetime);       -- @dtReturnValue is now last day of month      SET @dtReturnValue = DATEADD          (              DAY              ,-1             ,DATEADD             (                  MONTH                 ,1                 ,CAST(CAST(YEAR(@in_DateTime) AS varchar(4)) + RIGHT('00' + CAST(MONTH(@in_DateTime) AS varchar(2)), 2) + '01' AS datetime)              )         )     ;      -- SET DATEFIRST 1 -- Monday - Super easy !      -- SET DATEFIRST != 1 - PHUK THIS !      SET @dtReturnValue = DATEADD                         (                             day                             ,                              -                              (                                  (                                     -- DATEPART(WEEKDAY, @lastDayofMonth) -- with SET DATEFIRST 1                                      DATEPART(WEEKDAY, @dtReturnValue) + @@DATEFIRST - 2 % 7 + 1                                  )                                 %7                             )                             , @dtReturnValue     );      RETURN @dtReturnValue;  END   GO    GO    PRINT 'Done Executing "01_fn_dtLastSundayInMonth.sql"'    GO       PRINT 'Begin Executing "02_fn_dtIsCEST.sql"'   GO     IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[fn_dtIsCEST]') AND type in (N'FN', N'IF', N'TF', N'FS', N'FT')) BEGIN     EXECUTE(N'CREATE FUNCTION [dbo].[fn_dtIsCEST]() RETURNS int BEGIN RETURN 0 END ') END  GO      -- ===================================================================== -- Author:        Stefan Steiger -- Create date:   01.03.2019 -- Last modified: 01.03.2019 -- Description:   Ist @in_DateTime Mitteleuropäische Sommerzeit ?  -- ===================================================================== -- SELECT dbo.fn_dtIsCEST('2019-03-31T01:00:00'), dbo.fn_dtIsCEST('2019-03-31T04:00:00')  ALTER FUNCTION [dbo].[fn_dtIsCEST](@in_DateTime datetime ) RETURNS bit  AS BEGIN     DECLARE @dtReturnValue AS bit         -- https://www.linker.ch/eigenlink/sommerzeit_winterzeit.htm      -- the change from winter time to summer time is on the last sunday of March     -- the clocks will be put forward from 02:00 to 03:00. (one 'loses' an hour)      -- the change from summer time to winter time is on the last sunday of October:     -- the clocks will be put backward from 03:00 to 02:00 (one wins an hour).      DECLARE @beginSummerTime datetime      SET @beginSummerTime = dbo.fn_dtLastSundayInMonth(DATEADD(MONTH, 2, DATEADD(YEAR, YEAR(@in_DateTime)-1900, 0)) )       SET @beginSummerTime = DATEADD(HOUR, 2, @beginSummerTime)       DECLARE @beginWinterTime datetime      SET @beginWinterTime = dbo.fn_dtLastSundayInMonth(DATEADD(MONTH, 9, DATEADD(YEAR, YEAR(@in_DateTime)-1900, 0)) )        SET @beginWinterTime = DATEADD(HOUR, 2, @beginWinterTime)       SET @dtReturnValue = 0;      IF @in_DateTime >= @beginSummerTime AND @in_DateTime < @beginWinterTime      BEGIN          SET @dtReturnValue = 1;     END       RETURN @dtReturnValue; END   GO    GO    PRINT 'Done Executing "02_fn_dtIsCEST.sql"'    GO       PRINT 'Begin Executing "03_fn_dtToEcmaTimeStamp.sql"'   GO     IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[fn_dtToEcmaTimeStamp]') AND type in (N'FN', N'IF', N'TF', N'FS', N'FT')) BEGIN     EXECUTE(N'CREATE FUNCTION [dbo].[fn_dtToEcmaTimeStamp]() RETURNS int BEGIN RETURN 0 END ') END  GO      -- ===================================================================== -- Author:        Stefan Steiger -- Create date:   01.03.2019 -- Last modified: 01.03.2019 -- Description:   Ist @in_DateTime Mitteleuropäische Sommerzeit ?  -- ===================================================================== -- SELECT dbo.fn_dtToEcmaTimeStamp('2019-03-31T01:00:00', 1), dbo.fn_dtToEcmaTimeStamp('2019-03-31T04:00:00', 1)  ALTER FUNCTION [dbo].[fn_dtToEcmaTimeStamp](@in_DateTime datetime, @in_convert_to_utc bit) RETURNS bigint  AS BEGIN     DECLARE @dtReturnValue AS bigint          IF @in_convert_to_utc = 1      BEGIN         SET @in_DateTime =          CASE WHEN dbo.fn_dtIsCEST(@in_DateTime) = 1              THEN DATEADD(HOUR, -2, @in_DateTime)              ELSE DATEADD(HOUR, -1, @in_DateTime)          END;     END       SET @dtReturnValue =          CAST         (             DATEDIFF             (                 HOUR                 ,CAST('19700101' AS datetime)                 ,@in_DateTime              )             AS bigint         ) *60*60*1000         +          DATEDIFF         (              MILLISECOND              ,CAST(FLOOR(CAST(@in_DateTime AS float)) AS datetime)              ,@in_DateTime          ) % (60*60*1000)     ;      RETURN @dtReturnValue; END   GO    GO    PRINT 'Done Executing "03_fn_dtToEcmaTimeStamp.sql"'    GO       PRINT 'Begin Executing "04_fn_dtFromEcmaTimeStamp.sql"'   GO     IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[fn_dtFromEcmaTimeStamp]') AND type in (N'FN', N'IF', N'TF', N'FS', N'FT')) BEGIN     EXECUTE(N'CREATE FUNCTION [dbo].[fn_dtFromEcmaTimeStamp]() RETURNS int BEGIN RETURN 0 END ') END  GO     -- ===================================================================== -- Author:        Stefan Steiger -- Create date:   01.03.2019 -- Last modified: 01.03.2019 -- Description:   Ist @in_DateTime Mitteleuropäische Sommerzeit ?  -- ===================================================================== -- SELECT dbo.fn_dtFromEcmaTimeStamp('1551437088122', 1), dbo.fn_dtFromEcmaTimeStamp('1554069600000', 1)  ALTER FUNCTION [dbo].[fn_dtFromEcmaTimeStamp](@in_timestamp bigint, @in_convert_to_localtime bit) RETURNS datetime  AS BEGIN     DECLARE @dtReturnValue AS datetime           DECLARE @hours int      SET @hours = @in_timestamp /(1000*60*60);      DECLARE @milliseconds int      SET @milliseconds = @in_timestamp - (@in_timestamp /(1000*60*60))*(1000*60*60);       SET @dtReturnValue = DATEADD                          (                             MILLISECOND, @milliseconds,                              DATEADD(hour, @hours, CAST('19700101' AS datetime))                          )        IF @in_convert_to_localtime = 1      BEGIN         SET @dtReturnValue = DATEADD(HOUR, 1, @dtReturnValue)          SET @dtReturnValue =                                  CASE WHEN dbo.fn_dtIsCEST(@dtReturnValue) = 1                                      THEN DATEADD(HOUR, 1, @dtReturnValue)                                      ELSE @dtReturnValue                                  END;     END       RETURN @dtReturnValue; END   GO    GO    PRINT 'Done Executing "04_fn_dtFromEcmaTimeStamp.sql"'    GO  

What legal restrictions to photography are there in European countries?

I’m from Ukraine, and I know where I can shoot here and when. I had few trips to USA where I know it’s very difficult to shoot on the street, without encroaching on someone else’s private life.

I plan a travel to some of the European countries soon, but I don’t know what I can shoot, and what can I not?

Is there any proper information (e.g. government website or article) about photography rules in European countries? Is there any difference between photography rules in, for example, Germany and the Czech Republic?

European residence card

My name is Tracy I’m South African and hold a South African passport. I recently moved to Italy. I will be on a Sapphire Princess cruise ship from 4th of April which is in Messina until 18 May which is South Ampton… However , I will disembark the ship from Southampton and return back to Italy. I’m legally married to an italian, and therefore I hold….1) legalised Marriage Certificate,  2)Residence card for family member European citizen, 3)italian Teserra senitaria card. 4) Italian identity card… To fly from South Ampton with the following documents aswell as my husband along with me will I need a visa to transit through uk. ?

Why is it common in European airports not to display the gate for flights until around 45-90 minutes before departure, unlike other places?

https://youtu.be/wdU1WTBJMl0?t=262 mentions:

00:04:22: Heathrow also doesn’t display the gate for flights until around 45-90 minutes before departure. This is common in European airports, but uncommon elsewhere.

Why is it common in European airports not to display the gate for flights until around 45-90 minutes before departure, unlike other places?

Getting around a tethering block with European prepay SIM

When I travel to Europe, I buy a SIM, stick it in a Moto-E that has a European radio, then tether my regular cell phone. This has been an effective solution since I’m using my regular phone, and I have all my apps.

But, last time I traveled, I got a LycaMobile (Denmark) SIM, but they blocked tethering. The data connection worked fine from apps on the European phone. The wifi hotspot could be set-up on the European phone. My US cell phone successfully connected to the European phone’s wifi hotspot. But as we all know, unless there is Internet connectivity, having a successful wifi connection is useless. I went to two LycaMobile outlets and they confirmed that tethering is blocked for the plan I bought.

My question: would a user-space application (like PdaNet+) allow me to connect my US cell phone via wifi and allow me to access the Internet even though the normal Android tethering was blocked by the carrier?

(Moto-E, Android 4.4.2 (API 19))

Good name for european sextoy business

Why are you selling this site?
No time or focus to work with that

How is it monetized?
There is software which makes automatically sales for you.

Does this site come with any social media accounts?
No

How much time does this site take to run?
Its ready made

What challenges are there with running this site?
You just need to find audience for marketing it. Thats all.