Comments (3)
Aah, scrap that. Reading the docs, it says 'then the value used in the new row is a text representation of the current UTC date and/or time'. So if you're UTC+1, then an hour back is right.
https://www.sqlite.org/lang_createtable.html
from sqlitebrowser.
If you type select CURRENT_TIME
what result do you get?
sqlite would use the OS time .. what timezone is the OS in?
I've tried this on Linux and Windows, and get the same result on both.
from sqlitebrowser.
Thanks. Didn't find that. It's a bit hidden away.
from sqlitebrowser.
Related Issues (20)
- Port to Qt 6 HOT 1
- Rewrite Build Entries in the Wiki HOT 1
- Support for Branch-Specific Build Variants HOT 1
- [Bug]: Importing CSV with column headers doesn't work if columns are not in same order as table in DB HOT 1
- Quick Browse HOT 1
- [Feature]: Comment Line Shortcut key for "Execute SQL" tab and Shortcut Key selection screen HOT 3
- [Feature]: auto reopen last database HOT 8
- No data returned from SQL query HOT 2
- [Bug]: Can't run nightly build on macOS 12.7.4 HOT 7
- [Bug]: External drives cannot be opened on Ubuntu HOT 3
- [Bug]: Execute SQL Console overlaps text HOT 2
- [Feature]: Allow NOT operator '!' in front of filters
- [Bug]: Find and Replace fails to replace all finds HOT 1
- [Bug]: Copy/paste results of SQL select hangs / freeze program
- [Feature]: Plot - change axis to log scale
- [Bug]: When you start the program, an error message appears. HOT 6
- [Bug]: Unable to open databases with encoding UTF-16le HOT 6
- [Bug] The "File -> Export -> Database to SQL File ..." doesn't export the values in the "sqlite_sequence" table HOT 2
- [Bug]: Program crashes when executing SQL query
- [Bug]: crashed
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from sqlitebrowser.