This function generally used to get timestamp from miliseconds, date, timeuuid or other timely objects.
Questions tagged [to-timestamp]
35 questions
0
votes
1 answer
"AM/A.M. or PM/P.M. required" error though AM is used
I have table_name on oracle 12c which has column_name1 with data type "TIMESTAMP(6) WITH TIME ZONE". I am using SQL Developer.
When I select anything from this column_name1 using SQL Developer, I see the date like: 19-SEP-17 03.19.55.000000000 PM…
300
- 965
- 1
- 14
- 53
0
votes
1 answer
toTimestamp function is not working in select statement cassandra
I have table as
cqlsh> DESC relation.students;
CREATE TABLE relation.students (
student_id uuid,
created_at timeuuid,
name text,
PRIMARY KEY (student_id, created_at)
) WITH CLUSTERING ORDER BY (created_at DESC)
AND…
Nilesh
- 20,521
- 16
- 92
- 148
0
votes
1 answer
Oracle SQL to_date & to_timestamp ORA-01858: a non-numeric character was found where a numeric was expected & ORA-01850: hour must be between 0 and 23
I have a small bit of code:
Code
SELECT to_date(it.DSTAMP, 'DD/MM/YYYY') AS "Date", to_timestamp(it.DSTAMP, 'HH24:MI:SS') AS Time
FROM itable it
Errors
ORA-01858: a non-numeric character was found where a numeric was expected
01858. 00000 - "a…
Matt
- 14,906
- 27
- 99
- 149
-1
votes
1 answer
pyspark: change string to timestamp
I've a column in String format , some rows are also null.
I add random timestamp to make it in the following form to convert it into timestamp.
date
null
22-04-2020
date
01-01-1990 23:59:59.000
22-04-2020 23:59:59.000
df…
user12063090
- 39
- 7
-1
votes
2 answers
Converting NUMBER variable to Datetime stamp
I am using the following, where I am converting NUMBER variable to Datetime stamp.
to_char(
(to_timestamp('01-JAN-1970 00:00:00','DD-MON-YYYY HH24:MI:SS') +
(END_SAMPLE_TS_5MIN_MS/(1000*60*60*24)),'DD-MON-YYYY HH24:MI:SS')
But I notice the…
