SQL Developer is returning only the date, not the time. How do I fix this?

Here’s what SQL Develoepr is giving me, both in the results window and when I export: CREATION_TIME ——————- 27-SEP-12 27-SEP-12 27-SEP-12 Here’s what another piece of software running the same query/db gives: CREATION_TIME ——————- 2012-09-27 14:44:46 2012-09-27 14:44:27 2012-09-27 14:43:53 How do I get SQL Developer to return the time too? 8 Answers 8

Parsing RFC-3339 / ISO-8601 date-time string in Go

I tried parsing the date string “2014-09-12T11:45:26.371Z” in Go. This time format is defined as: RFC-3339 date-time ISO-8601 date-time Code layout := “2014-09-12T11:45:26.371Z” str := “2014-11-12T11:45:26.371Z” t, err := time.Parse(layout , str) I got this error: parsing time “2014-11-12T11:47:39.489Z”: month out of range How can I parse this date string? 8 Answers 8

How can I parse / create a date time stamp formatted with fractional seconds UTC timezone (ISO 8601, RFC 3339) in Swift?

How to generate a date time stamp, using the format standards for ISO 8601 and RFC 3339? The goal is a string that looks like this: “2015-01-01T00:00:00.000Z” Format: year, month, day, as “XXXX-XX-XX” the letter “T” as a separator hour, minute, seconds, milliseconds, as “XX:XX:XX.XXX”. the letter “Z” as a zone designator for zero offset, … Read more

Format date as dd/MM/yyyy using pipes

I’m using the date pipe to format my date, but I just can’t get the exact format I want without a workaround. Am I understanding pipes wrongly or is just not possible? //our root app component import {Component} from ‘angular2/core’ @Component({ selector: ‘my-app’, providers: [], template: ` <div> <h2>Hello {{name}}</h2> <h3>{{date | date: ‘ddMMyyyy’}}, should … Read more