I was making a small code to implement a treatment case in a friend application module and got stuck with a problem.
This is a unit test. To put in the application module I would have to make some adjustments when inserting into the native co...
How do I put the value of the field by default timestamp current?
I need to alterar my table to add a field timestamp not null which has the current default by default, so all previous records have the current timestamp t...
I have a service that before saving some value in the bank, it needs to be checked if it is within some time already saved in the bank. Each period consists of half an hour.
ex:
10:00
10:30
11:00
If the user tries to put 10:31, an exception...
I have a timestamp column in my table and I need to pick up only those time values.
Example of how you are registered: 30.12.1899 17:03
Example of how I need to display via select: 17:00
I got it this way:
SELECT
CASE
WHE...
I need to save only hour and minutes (seconds do not make a difference, so have or do not), should I use TIME or TIMESTAMP ?
I started to do with TIMESTAMP(6) , but I'm having a hard time doing insert , what should I...
I have the following query:
SELECT name, commission, timestamp, state_name
FROM magry_awoaffiliate_commission c
INNER JOIN magry_users u ON (c.user_id = u.id)
INNER JOIN magry_virtuemart_userinfos v ON (c.user_id = v.virtuemart_user_id)
INNER...
Good morning, someone can help me? I have a Java application and I need to do a conversion .. In which is the localDate for unixtime .. How can I do this?
This is my localDate:
for (Telemetry telemetry : listTelemetry) {
telemetry...
My conversion from timestamp to calendar was apparently successful, since the data presented appears correct except for the day of the week.
data = (java.util.GregorianCalendar)
java.util.GregorianCalendar [time = -125784706799416, areFi...
Personal speech.
I'm having some problem trying to use the library momentjs to work with dates.
My problem is described below.
****--------- Datetime ----------****
Timestamp recebido do banco de dados -> 2016-07-12 17:21:40 <- ES...