× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
NielsGron reported 2016-07-30T03:22:19Z  · tariqrahiman last modified 2016-08-24T18:11:35Z

Write equivalent queries for all databases like I have done for MySQL and PostgreSQL


Dev shilpasingh(*)
QA
Jenny Nishimura
JennyNishimura
Priority Major
Complexity Unknown
Component Q Analyzer
Version 17.0

Write equivalent queries for all databases as these two for MySQL and PostgreSQL :

MySQL :
select  current_date() as cur_date,
        current_time() as cur_time,
        current_timestamp() as cur_timestamp,
        utc_date() as cur_utc_date,
        utc_time() as cur_utc_time,
        utc_timestamp() as cur_utc_timestamp
go
select  cast(current_date() as char) as cur_date,
        cast(current_time() as char) as cur_time,
        cast(current_timestamp() as char) as cur_timestamp,
        cast(utc_date() as char) as cur_utc_date,
        cast(utc_time() as char) as cur_utc_time,
        cast(utc_timestamp() as char) as cur_utc_timestamp
 

PostgreSQL :
select  current_date as cur_date,
        current_time as cur_time,
        current_timestamp as cur_timestamp,
        current_date at time zone 'UTC' as cur_utc_date,
        current_time at time zone 'UTC' as cur_utc_time,
        current_timestamp at time zone 'UTC' as cur_utc_timestamp
go
select  to_char(current_date, 'MM-DD-YYYY') as cur_date,
        //to_char(current_time, 'HH24:MI:SS') as cur_time,
        to_char(current_timestamp, 'MM-DD-YYYY HH24:MI:SS TZ') as cur_timestamp,
        to_char(current_date at time zone 'UTC', 'MM-DD-YYYY') as cur_utc_date,
        //to_char(current_time at time zone 'UTC', 'HH24:MI:SS') as cur_utc_time,
        to_char(current_timestamp at time zone 'UTC', 'MM-DD-YYYY HH24:MI:SS') as cur_utc_timestamp
 

3 attachments

Issue #14589

Closed
Fixed
Resolved 2016-08-01T18:43:30Z
 
 
Completion
No due date
No fixed build
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017