Questions tagged as 'datetime'

Tagged questions
2
answers

Calculate difference between dates with time zone

I need to calculate the difference between 2 dates with different time zone: The calculation is between the post date and the current date.    Assuming a post is America/Sao_Paulo and another post Europe/Amsterdam .   For each...
asked by 24.07.2014 / 05:38
1
answer

Passing Date parameters for queries

I'm having a problem when passing a parameter. I tried debugging by passing Date to string, but the problem arises that a number is expected instead of a character. After that I researched other ways and tried to pass parameters in the...
asked by 30.08.2018 / 14:19
1
answer

Using date picker in asp.net

I'm creating a site in asp.net (vb) with a master page behind it and I can not get the date picker to work Can you help me or indicate a date picker even for the nuggets?     
asked by 30.04.2018 / 11:23
1
answer

Query with date in sql includes the day in question?

I have a question about the exact days that SQL includes, and my system once per day performs the following query on the system: SELECT id,nome FROM products WHERE created_date between \'"+last_date+"\' and \'" + now+"\' Where to...
asked by 22.02.2018 / 16:27
1
answer

Wrong date format in xamarin forms, how to solve?

In my mobile application I have a part that I retrieve the local date and time, so the date is bringing the month first, then the day and last year, how to change it, here is my code: In my layout file: <Label Text="Data" FontAttribu...
asked by 15.02.2018 / 18:00
1
answer

Error entering date in sprint on jira

When I try to start my sprint, this error appears in the jira     
asked by 12.12.2017 / 22:35
1
answer

Correct alternative that implements a validator for a date field in Laravel

a. $this->validate($request, [ 'data_nascimento' => 'regex:ddmmyyyy', ]); b. $this->validate($request, [ 'data_nascimento' => 'required|date', ]); c. $this->validate($request, [ 'data_nascimento' => 'dig...
asked by 01.11.2017 / 00:38
2
answers

How to post date and time using type '' datatime '' in sql

PHP: $date = new DateTime(); print_r ($date); result: DateTime Object ( [date] => 2017-11-07 15:51:26.000000 [timezone_type] => 3 [timezone] => America/Sao_Paulo ) Okay, see you later. Database (sql). Extras table:...
asked by 07.11.2017 / 19:12
1
answer

How to compare a date of type datetime?

I have a date in a patient table in the Sql Server database in the following format: datetime (01/01/2016 12:50:00.000) I want to check if the patient's appointment time has arrived. For example: The time of the appointment is at 13:00...
asked by 30.10.2016 / 16:42
1
answer

SimpleFormatData returning null HH: mm: ss

I need to get only the time entered by the user, but the method I did returns null when I try to change the format to HH:mm:ss public static Date formataData(String data) throws Exception { if (data == null || data.equals("")...
asked by 25.06.2016 / 17:37