Questions tagged as 'datetime'

Tagged questions
1
answer

Returning difference between dates with days and months

I'm developing a C # function that calculates the interest applied to a particular account. for this it is necessary to know the correct difference between days and months. How can you perform a function in C # that returns the number of days...
asked by 19.07.2017 / 00:46
1
answer

Use Separate DataHora

I have a DataHora field and wanted to use separate, that is, a single field in the database called DateHora of type datetime, and manipulate this field with two editorfor where I saved the date of one editorfor and the time of another editorfor...
asked by 29.10.2016 / 05:34
1
answer

Get the current date directly from the machine

I need to implement the functionality of getting the date directly from the machine in my project (library system). I wanted it in the format dia/mês/ano , to generate the fine for book delivery delay automatically, however, I can only get...
asked by 16.10.2016 / 15:51
2
answers

How to do a select in date format?

How do I perform a select using dates in SQL server 2008 ? When I do a search with this select: select * from NOME_TABELA where DATA_FISCAL between '2016-05-01' and '2016-05-11' The result is 12 records including one record has the da...
asked by 13.05.2016 / 17:04
1
answer

Query with date in variable in MySQL returning empty

I need to make a query in MySQL setting 3 variables, when I know in the case of integer number of the right one, more when I include data ta returning empty. Follow my query , what could be doing wrong? SET @tipo = 47; SET @dataini = 201...
asked by 04.05.2016 / 21:35
1
answer

How to restrict the values of a date in a field of a form in java?

I have a form built with Swing (Java) that has some fields, among them there is one that is the Birth Date (a String that receives the value of a date and has a formatted field ##/##/#### .) is represented by the variable jTFData...
asked by 27.03.2016 / 20:00
1
answer

Delete expiration date information in Wordpress posts

I'm using the code below to tell how long it takes for a post to expire on my Wordpress website, whose expiration value I set in a Custom Field (expiration). From this code, since I prevent a post from expiring in 4 hours, do not display info...
asked by 12.02.2016 / 18:33
1
answer

How to put the current date and time in a datetime field? [closed]

I have a date field in a table that is of type datetime and I want to put the current date of my server. Ihavetriedeverything,withNOW()intheinsertionSQL,butthenIsawthatitdoesnotwork.IalreadytriedtochangetheDEFAULToffielddatetoCURREN...
asked by 19.01.2016 / 11:01
1
answer

Start / End of Summer Schedule: problem with date verification of type "greater than"

Every year I have two problems, one when summer time begins and the other when it's over. Anyway, yesterday the clock was delayed in an hour that created a giant problem. The page should allow the user to access it only with a time interva...
asked by 21.02.2016 / 13:15
2
answers

DateTimePicker, get first and last day of the month [closed]

How do I get the first and last day of the previous month, to fill a% on screen with%? Ex: Data Inicial 01/07/2015 Data Final 31/07/2015     
asked by 12.08.2015 / 15:12