Questions tagged as 'datetime'

Tagged questions
3
answers

Format a string with time

I'm trying to format a string that already has date and time, but this string just has to get the time I'm trying in this way more does not work: > Recovering from the database. string dtSolicitacao = String.IsNullOrEmpty(Convert.ToStri...
asked by 27.08.2015 / 14:01
1
answer

How to calculate days, ignoring hours

How can I calculate if you spent 1 day, ignoring the hours. Explaining, it would look something like this: I have a date 2017-09-09 11:45:20 , normally it would have been 1 day, when the 11:45 arrived the other day, however I would li...
asked by 10.09.2017 / 18:21
1
answer

How to filter time in a datime field in eloquent?

How can I compare if a time is equal to a time stored in a datetime column using Eloquent?     
asked by 25.10.2018 / 19:24
2
answers

Convert a date to javaScript

Good afternoon. How do I convert a date to javaScript, taking into account the entered date can be format day-month-year or year-day-month. I have the following code: data = toDate('2015-10-01'); function toDate(dateStr) { dateStr...
asked by 14.12.2015 / 16:43
1
answer

Convert string to specific format in date

I have a string "sex, nov 6" and need to convert to DateTime . I'm doing it this way: DateTime datetime = DateTime.Parse(gridT.Columns[e.ColumnIndex].HeaderText.ToString()); But it is not working. How can I do this conv...
asked by 06.11.2015 / 12:42
1
answer

Format date in Android and SQLite

I am having difficulty setting the current date of my SQLite database in the% type attribute of my object. The SQLite date comes in the format "yyyy-MM-dd". I'm trying to convert to the format accepted in type java.util.Date and that a...
asked by 15.11.2015 / 06:27
1
answer

Convert timestamp value to date

I have a timestamp value of a date, 1389135600 , how can I convert this value to a date of this type 27/12/2014 .     
asked by 27.12.2014 / 12:38
1
answer

Trigger that calculates and updates age

I want to create a trigger that, when triggered, calculates the age of the client in each row of the table and updates if necessary. I tried the following: create trigger Atualiza_Idade on cliente for insert,update,delete as declare @i in...
asked by 05.03.2015 / 18:08
1
answer

What exactly does the DateTime :: createFromImmutable () method serve?

What exactly is the DateTime::createFromImmutable() method for? Implemented according to release note of PHP version 7.3.0.     
asked by 21.12.2018 / 02:36
1
answer

If I have two servers (application and database) with different time zones, which one is better to use as a base?

I am working with the MySQL server of a hosting, I can not change the time zone of the same, ie it uses the "Mountain Standard time (MST)", on the other hand, I am using the ASP.NET server and in it I can set the time zone for "Brasilia Timetabl...
asked by 10.01.2018 / 18:49