Comments (1)
There is no way to convert an integer into a date string built into SQLIteBrowser. This is mainly because there is no way for us to tell whether a value is to be converted or not. It's made even worse by SQLite allowing all sorts of data types to be mixed even in the same column (i.e. the same column may contain an integer for one row and e.g. a string for the next row, so these column-depending actions require us to do a lot of data checks).
What you can do though - and what I do for one database I have with epoch dates - is using the native 'datetime()' SQLite function by executing this in the Execute SQL tab of SQLiteBrowser:
SELECT *,datetime(date_column, 'unixepoch') AS date_column_string FROM table_name;
You could also create a view of this by clicking the button next to the result view and then on "Save as view".
For more details and examples on this you may want to check https://www.sqlite.org/lang_datefunc.html
I hope this helps you a bit!
from sqlitebrowser.
Related Issues (20)
- [Feature]: Save plot as SVG
- Error in error log; (21) API called with NULL prepared statement HOT 2
- [Bug]: Changing the display format of a column destroys its sort order HOT 2
- [Bug]: Pin To Taskbar Windows10
- [Bug]: Some UI text don't scale according to font size settings. HOT 3
- [Bug]: Exact filter on COUNT() column doesn't work HOT 10
- [Bug]: Assertion [cpMax <= pdoc->Length()] failed at ../scintilla/src/Editor.cpp 6096 HOT 3
- [Feature]: Fix ordering of schema export HOT 3
- [Bug]: creation of new db file upon attach of non-existing file fails. HOT 2
- [Feature]: "Filter in any column" should only filter in '__rowid__' is visible HOT 3
- Add Debug Information to 'Continuous' Release HOT 2
- Check Update for Unstable Build HOT 1
- 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 7
- No data returned from SQL query HOT 2
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.