I need to add a dot in two strings of numbers. (example “88188741478”). I need to add it 8 characters before the end. The result should look like this “881.88741478”. I need …
Tag: formatting
pyscopg2: Is it possible to dynamically add %s in loop
I am trying to create a method in python insert records into a table passing in a list of column names, and an associated list of records. I was able to set it up where the column names populated dynamically via a for loop, but I can’t figure out how to do the same thing with values because the psycopg2…
Formatting names in a single column in sql oracle
I need to help. I am new in tha oracle. I have a simple problem. My table: create table employee (name varchar2(30)); insert into employee values (‘kevin durant’); insert into employee values (‘…
Fraction formatting as halves or one third or quarters in PostgreSQL
I have some double-precision values in a column in PostgreSQL as following: I want to round these values to their nearest quarter value at the decimal place. That is: I saw this kind of feature in MS Excel. It can be found at: How can I do the same in PostgreSQL? Thanks in advance for your help. Answer You ca…
MySQL = Grouping Sales Count by Months, then Displaying months as Names (Jan, Feb…DEC) not Numerical Value (1,2,3-12)
This seems like a reasonably simple problem but I cannot figure out how to change a numerical value of a month into the months actual name after the sales count is grouped by the month. Basically I …
number formatting 9’999.00
I’d like to format a number in a SQL select like this How can I do this? It works for 9,999,999 with the following command Answer You are almost there. Just replace group separator (.) with a single quote (‘) and you are good to go. result:
Formatting bigdecimals sql oracle
To have a readable big numbers under oracle and to facilatet the reading, I’m looking for a way to add blank space to obtain something like that: 213537592384.236 ===> 213 537 592 384.236 The problem that I have big numbers like above. Answer Spaces are a curious separator, and not directly supported…
SQL server 2012 SP_HELPTEXT extra lines issue
I am using SQL server 2012, & always use SP_HELPTEXT to get my previously created Stored Procedures, In previous versions of SQL server there were no issues in this process but in 2012, My Stored Procedures come with extra lines, for example this is the procedure that I wrote Now after using SP_HELPTEXT w…
SQL Server Convert Varchar to Datetime
I have this date format: 2011-09-28 18:01:00 (in varchar), and I want to convert it to datetime changing to this format 28-09-2011 18:01:00. How can I do it? Answer
Remove trailing zeros from decimal in SQL Server
I have a column DECIMAL(9,6) i.e. it supports values like 999,123456. But when I insert data like 123,4567 it becomes 123,456700 How to remove those zeros? Answer A decimal(9,6) stores 6 digits on the right side of the comma. Whether to display trailing zeroes or not is a formatting decision, usually implemen…