Just a Web Code Solution
date and time between different platform sql ?
165
SQL
0
By 9 years ago
The power of the user (%)
0
// defining date and time
mysql: DATETIME
microsoft sql: DATETIME
oracle: DATE
// inseting current date and time
mysql: NOW() SYSDATE() CURRENT_TIMESTAMP
microsoft sql: GETDATE()
oracle: SYSDATE
// inserting specific date and time
mysql: '25.5.2016 13:30:51'
microsoft sql: '25.5.2016 13:30:51'
oracle: TO_DATE('25.5.2016 13:30:51', 'dd.mm.YYYY, HH24:MI:SS')
By 9 years ago
The power of the user (%)
The most helpful SQL solutions
how to execute select into using sql ?SQL
Click to see more ...
726
53
convert string to date sqlSQL
Click to see more ...
641
42
How to get the last record from table using sql ?SQL
Click to see more ...
558
33
create table sqlSQL
Click to see more ...
333
23
How use like using sql ?SQL
Click to see more ...
412
22
How to get the last 10 records using mysql ?SQL
Click to see more ...
309
21
rows to columns sqlSQL
Click to see more ...
264
17
insert new column into table sqlSQL
Click to see more ...
265
16
How to convert the values to lowercase using sql ?SQL
Click to see more ...
284
13
How to change a negative number to positive using sql ?SQL
Click to see more ...
220
11
- Related solutions:
- convert string to date sql
641 42 - get date from datetime sql
195 1 - select year from datetime sql
215 1 - How to update record using sql ?
155 0 -
Vote
0
- Latest solutions:
- create table sql
333 23 - insert new column into table sql
265 16 - rename column sql
227 3 - convert string to date sql
641 42 - get date from datetime sql
195 1 - get part of a string sql
198 0 - select year from datetime sql
215 1 - create table from select sql
246 3 - rows to columns sql
264 17 - delete table from databse sql
202 1 - Helpful solutions:
- how to execute select into using sql ?
726 53 - convert string to date sql
641 42 - How to get the last record from table using sql ?
558 33 - create table sql
333 23 - How use like using sql ?
412 22 - How to get the last 10 records using mysql ?
309 21 - rows to columns sql
264 17 - insert new column into table sql
265 16 - How to convert the values to lowercase using sql ?
284 13 - How to change a negative number to positive using sql ?
220 11
SQL
Would you like to receive an e-mail notification when new SQL solution is created?