All Questions
5,130
questions
0
votes
0
answers
11
views
mysql current_timestamp format as MM-DD-YYYY HH:MM:SS ? in an insert into? VBNET [duplicate]
I might want to insert the current date time into a MySQL datetime column using the format as described in the question title.
Not as YYYY-MM-DD
I don't know if this is done or your supposed to format ...
- 21
0
votes
2
answers
107
views
TimeZones In Laravel Application
I have made a laravel application which save data in db as UTC. My client is in South Africa and he wants the records to be displayed in South Africa timezone. Any body guide me related to this.
...
0
votes
2
answers
33
views
Joining two MySQL tables where timestamp is not same in both
I have two tables 'poolTemp' and 'weather'. Both tables contain the columns "timeStamp" and "tempC". I want to join the tables with both "tempC" but only when poolTime....
- 11
0
votes
0
answers
32
views
Conversion of hour format in python flask
I want to change the hour format from 24 to 12. This is an attendance project and the following python code linked with HTML to show up the attendance from the database. And this is the code
from ...
- 1
0
votes
0
answers
53
views
How to change an field in SQL in a specified amount of time?
For context: My table is organized like this:
id
start
end
status
The current time can be entered (is is the default value), or the time the user prefers. The end time is set to always be two hours ...
1
vote
1
answer
34
views
Datetime Formats
Mysql noobie here. I'm trying to load a csv file that has 2 types of date format: 1 is dd/mm/yyyy and the other is dd/mm/yyyy hh:mm.
I gather that mysql has a standard datetime format, which is ...
- 31
0
votes
0
answers
15
views
Add PHP DateInterval to MySQL value in query
I want to build a script that check for overdue schedules. Based on the creation date and the interval of the schedule it should get noted as overdue. For example I've created a schedule now, and with ...
- 23
0
votes
0
answers
24
views
SQL - Fill timestamp gaps and split rows to monitor complete days
I have the following data set in a SQL DB:
enter image description here
And that's what I want to achieve:
enter image description here
This results in 4 tasks:
1. if an entry extends over one day, an ...
- 1
0
votes
0
answers
36
views
how to output datetime with timezone offset in mysql
I have a datetime stored in table with timezone offset to 'America/New_York' in MySQL.
I wanted to display SQL query output as "year-month-date'T'24Hour:Minute:Second.microseconds(+/-)offset"...
- 502
-4
votes
2
answers
164
views
Format specific MySQL DateTime YYYY-MM-DD in C# with Microsoft Entity Framework
I get an error when insert record in MySQL database with Microsoft Entity Framerk.
Mi table is
CREATE TABLE IF NOT EXISTS `preventive` (
`IDPREVENTIVE` mediumint(9) NOT NULL AUTO_INCREMENT,
`...
0
votes
0
answers
40
views
Join tables and sort by max date between the two tables and it's entries (there are two dates each)
I have two tables sgroup and sitem. both sgroup and sitem have a created and modified property (which are of type DATETIME and can be NULL).There can be many sitem entries for each sgroup. I'd like to ...
- 910
0
votes
0
answers
16
views
How do I deal with a column name/field name 'time@timestamp' in MySQL workbench [duplicate]
I have imported machine logs coming from data collection devices, transferred by easybuilder pro. So far, in terms of cleaning the data and formatting for correct data types has been straightforward.
...
- 1
0
votes
0
answers
18
views
Node.js + Mysql DateTime is saved one hour earlier in database
I'm new in Node.js.
I'm working on a Node.js project which uses express, squelize. moment.js and mysql. Mysql gets build in Docker.
The problem is, when I want to save a datetime in the database, the ...
- 292
0
votes
0
answers
24
views
laravel ajax submitting schedule interview form error
I want to store schedule interview information using laravel and ajax. but I got an error.I use datetime for input type of schedule time.but I guess the mysql doesnt allow my datetime data that had ...
0
votes
2
answers
107
views
mysql virtual column incoherence wrt from_unixtime()
Got a table with a virtual column using from_unixtime():
CREATE TABLE aa (
id int NOT NULL AUTO_INCREMENT,
epochmillis bigint,
session_dt DATETIME(3) generated always as (from_unixtime(epochmillis/...
- 1,810