StackOverflow Questions for Tag: to-char

Taylan Morcol
Taylan Morcol

Reputation: 23

SQL: to_char not always returning text (PostgreSQL, DataCamp)

Score: 0

Views: 54

Answers: 1

Read More
5120bee
5120bee

Reputation: 709

Formatting a '$' dollar sign to an SQL Selection Statement with SUM() in it?

Score: -2

Views: 3221

Answers: 2

Read More
an0nhi11
an0nhi11

Reputation: 59

In oracle, why does 1 divided by 0 require a TO_CHAR function?

Score: 0

Views: 637

Answers: 3

Read More
kaycee17
kaycee17

Reputation: 13

Use day name from DATE in another field as the key in a JSONB query in postgresql

Score: 1

Views: 39

Answers: 1

Read More
Utkarsh
Utkarsh

Reputation: 3

SQL Developer returning incorrect date when formatted using TO_CHAR function

Score: 0

Views: 38

Answers: 1

Read More
lee chen
lee chen

Reputation: 1

postgresql function inserts new records with the pass-in timestamp parameter problem

Score: 0

Views: 35

Answers: 0

Read More
JCoder
JCoder

Reputation: 23

Date Range - Issues retrieving values in date range when date is saved as a varchar formatted: DD-MON-YY

Score: 0

Views: 85

Answers: 1

Read More

Using to_char to convert number or date with xmltable

Score: 1

Views: 343

Answers: 2

Read More
Shyam Sunder A C
Shyam Sunder A C

Reputation: 1

'09/11/2023' changes '20/11/0009' in Oracle

Score: 0

Views: 58

Answers: 1

Read More
Boudu
Boudu

Reputation: 87

Output formatting - ORA SQL - TO_CHAR(fm00.00)

Score: 0

Views: 145

Answers: 1

Read More
Jithesh Nair
Jithesh Nair

Reputation: 139

Convert date to YYYY-MM-DDThh:mm:ss.sssZ format in Postgresql

Score: 4

Views: 8387

Answers: 1

Read More
BFF
BFF

Reputation: 396

ORA-01481: invalid number format model (convert number to char)

Score: 0

Views: 409

Answers: 2

Read More
Yamez
Yamez

Reputation: 25

How to check for a specific date with a CASE statement in SQL in Oracle SQL

Score: 0

Views: 535

Answers: 2

Read More
John Cowan
John Cowan

Reputation: 1684

PostgreSQL TO_CHAR() Remove Padding on Month Field

Score: 11

Views: 4012

Answers: 1

Read More
lit
lit

Reputation: 16266

Formatting date when using CAST

Score: -1

Views: 6378

Answers: 2

Read More
user3646666
user3646666

Reputation: 17

Oracle DB Date Field Problem about to_char function

Score: 0

Views: 843

Answers: 2

Read More
user2219385
user2219385

Reputation: 45

using TO_CHAR of TIMESTAMP throws ORA-01877 if it's more than 78 characters

Score: 2

Views: 2672

Answers: 2

Read More
Aasem Shoshari
Aasem Shoshari

Reputation: 49

Oracle SQL group by to_char - not a group by expression

Score: 0

Views: 198

Answers: 1

Read More
Ravi
Ravi

Reputation: 31437

how to display number value in words

Score: 2

Views: 21396

Answers: 4

Read More
Emmanuel Njorodongo
Emmanuel Njorodongo

Reputation: 1302

Unknown database function 'DATE_FORMAT' in OracleDb

Score: 0

Views: 605

Answers: 1

Read More
PreviousPage 1Next