This video we are going to discuss the NUMBER data type. The Number data type is used to store integers, and real numbers. When you create a column as a NUMBER, you can store pretty huge or pretty small numbers in this column. Now there are two things you need to consider when working with numbers, and that is the precision as well as the how big the number is.
For example, we can store the number 9.9. This has two significant digits. We could also store the number 9.9 X 10^4. In this situation, the number is much larger, but the number of significant digits is the same. 9.9 are the significant digits. When we expand this out we just have 99000, and the zeros are just used for size and are not considered "significant" in this situation. In fact, you get a max precision of 38, but a maximum value of 9.99 * 10^125. You can also use this data type to store very small numbers. Check the docs for the specifics on maximums and minimums.
You can provide it with two pieces of information:
Precision - The total number of digits.
Scale - The number of digits to the right of the decimal.
You do it in this format: NUMBER (precision, scale).
The important thing to remember in this is that when you specify a precision, you will be limiting the max size of the numbers.
The secret behind this data type is that it is actually stored in scientific notation. That is we store a number and then we can multiply it by 10 raised to some power. This allows us to store much larger numbers without taking up a ton of space.
The oracle docs actually gives a formula that you can use to see how much storage is going to be required for a specific NUMBER data type.
How much precision can be used? The acceptable range is 1-38.
What about scale? The range is actually -84 to 127. I'll explain the scale in more detail in an upcoming video. That's because there is a lot of confusing things here…What does it mean for the scale to be negative? How can we have a scale that is bigger that the total number of digits available through the precision. That's a topic for another video.
It's important to understand that when we increase our scale, we decrease the max size of the number. For example if we have a precision of 5 and a scale of 3, the highest number we can store is 99.999. This is in contrast to a precision of 5 and a scale of 2 which allows for up to 99.999. Either way you get 5 significant digits, but the numbers of digits to the left and right of the decimal change.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Support me! http://www.patreon.com/calebcurry
Subscribe to my newsletter: http://bit.ly/JoinCCNewsletter
Donate!: http://bit.ly/DonateCTVM2.
~~~~~~~~~~~~~~~Additional Links~~~~~~~~~~~~~~~
More content: http://CalebCurry.com
Facebook: http://www.facebook.com/CalebTheVideoMaker
Google+: https://plus.google.com/+CalebTheVideoMaker2
Twitter: http://twitter.com/calebCurry
Amazing Web Hosting - http://bit.ly/ccbluehost (The best web hosting for a cheap price!)

Views: 8492
Caleb Curry

Please Subscribe Channel
Like, Share and Comment
Visit : www.geekyshows.com

Views: 8083
Geeky Shows

The DECIMAL data type is similar to the INT data type in that when you use the number for math, it maintains precision. The difference though is obvious in the name. The DECIMAL data type allows for numbers after a decimal point (and before the decimal point). The DECIMAL data type allows us to store what is known as a fixed-point number. A fixed point number is a number that has a specific number of digits available to store numbers in. That means we can't do things like use a DECIMAL data type to store as many digits of PI as possible, because we can't store unlimited digits. We are limited to a certain number.
There are two keywords you need to understand when you are working with the DECIMAL data type, precision and scale. Precision is the number of digits and scale is the number of those digits that will come after the radix. You are going to want to provide these numbers when you declare a column of this data type.
For example, DECIMAL(5, 2) has a precision of 5 digits and a scale of 2 digits. That means we can store a maximum of two digits after the decimal and four digits total. This gives us a possible range from -999.99 to 999.99
The highest number of digits is 65, and the highest number of digits after the decimal is 30.
This data type is also known as DEC, NUMERIC, and FIXED.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Support me! http://www.patreon.com/calebcurry
Subscribe to my newsletter: http://bit.ly/JoinCCNewsletter
Donate!: http://bit.ly/DonateCTVM2.
~~~~~~~~~~~~~~~Additional Links~~~~~~~~~~~~~~~
More content: http://CalebCurry.com
Facebook: http://www.facebook.com/CalebTheVideoMaker
Google+: https://plus.google.com/+CalebTheVideoMaker2
Twitter: http://twitter.com/calebCurry
Amazing Web Hosting - http://bit.ly/ccbluehost (The best web hosting for a cheap price!)

Views: 8332
Caleb Curry

Example that shows how to get numbers after decimal (.)dot
Also how to fix the following error The data types float and int are incompatible in the modulo operator.
More info: http://howtodomssqlcsharpexcelaccess.blogspot.ca/2013/01/how-to-fix-error-data-types-float-and.html
and here
http://howtodomssqlcsharpexcelaccess.blogspot.ca/2013/01/mssql-how-to-get-numbers-after-decimal.html

Views: 1664
Vis Dotnet

FLOAT and DOUBLE data types are data types that can be used to store numbers that can include decimal numbers. They are specifically used to store estimates. What do I mean? I mean that the precision of a FLOAT or DOUBLE value can be lost when doing math. The data types are only capable of maintaining a certain level of precision. The level of precision is usually adequate for most mathematical operations. If you need to store exact data, you will want to look into using the INT or DECIMAL data type instead.
The numbers stored in a FLOAT or DOUBLE column are called floating point numbers, we'll see why in just a moment.
Why are they called floating point numbers? let's look at a number. 150. This number could be represented as 150, or it could be represented as 1.5 * 10^2, or 1.5e2. With floating point numbers, scientific notation is used. These numbers are called floating point numbers because the decimal can float to different spots as we change the exponent.
This means that the data type needs to store the number, how many decimal the number needs moved, and a sign bit.
The benefit of floating point numbers is that they allow us to store pretty huge numbers. The down side is that they are not storing values exactly because they are limited in size. This means that only a certain level of precision is to be expected from a floating point data type.
If you remember from the video of DECIMAL, precision is the number of digits in a number. As long as the precision for one of these data types exceeds the need for your specific data, the data type can work fine. For example, if you are storing a number like 15 trillion, you don't have to worry as much with precision as your number does not contain a lot of digits. This number can be represented as 1.5 x 10^13. This is a lot different than trying to store 1.5534534534 x10^13.
Now we know both of these data types do not maintain a high number of digits correctly, but what is the difference between FLOAT and DOUBLE. The difference is the amount of storage they take up. Float takes up 4 bytes while DOUBLE takes up 8. The benefit in DOUBLE is that because it has more room to store data, it has a higher level of precision and can store bigger numbers.
Now, what level of precision can you expect from either of these? FLOAT around 7 and DOUBLE around 15. Now, these data types are obnoxious because the exact values depend on your operating system and in general these monsters cannot be trusted. Especially when you start doing math with different numbers. In general, it is recommended to use the DOUBLE data type to have a higher level of precision and calculations in MySQL are done with DOUBLE.
Always remember… prepare for trouble, make it double.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Support me! http://www.patreon.com/calebcurry
Subscribe to my newsletter: http://bit.ly/JoinCCNewsletter
Donate!: http://bit.ly/DonateCTVM2.
~~~~~~~~~~~~~~~Additional Links~~~~~~~~~~~~~~~
More content: http://CalebCurry.com
Facebook: http://www.facebook.com/CalebTheVideoMaker
Google+: https://plus.google.com/+CalebTheVideoMaker2
Twitter: http://twitter.com/calebCurry
Amazing Web Hosting - http://bit.ly/ccbluehost (The best web hosting for a cheap price!)

Views: 8276
Caleb Curry

more info
http://howtodomssqlcsharpexcelaccess.blogspot.ca/2018/02/mssql-round-decimal-to-2-decimal-places.html

Views: 604
Vis Dotnet

https://www.databasestar.com/oracle-months_between/
The Oracle MONTHS_BETWEEN function allows you to find the number of months between two dates. You can enter two dates and the function returns the difference.
This function is often used as part of other calculations. Sometimes you’ll want to know the difference between two dates to perform other functions.
The syntax of the MONTHS_BETWEEN function is:
MONTHS_BETWEEN(date1, date2)
What do these two parameters mean?
The function performs date1 minus date2. So, if date1 is larger, the result is positive. If date2 is larger, then the result is negative.
What data type is returned?
It depends on the values you provide. If the dates are both on the same day of the month (e.g. both on the 10th of the month), then the result is an integer or whole number. If not, then the result will be a decimal value.
For more information on the MONTHS_BETWEEN function, including the code used in this video and examples, read the related article here:
https://www.databasestar.com/oracle-months_between/

Views: 1011
Database Star

--How to convert Number To $ Currency Format in SQL
SELECT 1234567 as [Currency Format]
--Out Put $1,234,567
--2 Methods
--Method 1
--For SQL Server 2012, or later, an easier solution is to use Format function
SELECT '$' + Format('1234567', '#,00') as [Currency Format]
--Method 2
SELECT '$'+replace(convert(varchar,cast(1234567 as money),1), '.00','') as [Currency Format]

Views: 138
shabbeer Code Hack mujawar

Session 6:
Datatypes In Oracle
ALPHABET : A-Z , a-z
NUMBER : 0-9 (with precision and scale)
DATE / Temporal : any Date and time (Hours, Minutes, Seconds, Mili-seconds, Timestamp, Timezone etc)
Alphabet + Number = Alphanumeric Data
= String / CHARACTER Datatype Category
Number = Numeric Datatype Category
Date = Date Datatype Category
1. CHARACTER Datatype:
CHAR, VARCHAR, NCHAR:
CHAR is fixed length datatype and VARCHAR is Variable length datatype to store character data. i.e. A-Z , a-z , 0-9 , all keyboard characters etc.
The default size is 1 character and it can store maximum up to 2000 bytes.
Example : EName, EmpID, PassportNo, SSN, etc.
EName CHAR(10) := ‘TOM’; wastage of 7 space after the string
EName VARCHAR(10) := ‘TOM’; Spaces can be Reuse which left after the string
NCHAR additionally handles NLS(National Language Support).
Oracle supports a reliable Unicode datatype through NCHAR , NVARCHAR2 , and NCLOB
VARCHAR2, NVARCHAR2:
These are Variable length datatype.
VARCHAR2 handles alphanumeric character string whereas NVARCHAR2 handles alphanumeric character string with NLS(National Language Support).
The default size is 1 character and it can store maximum up to 4000 bytes.
LONG: Variable length string. (Maximum size: 2 GB - 1)
Only one LONG column is allowed per table.
RAW: Variable length binary string (Maximum size 2000 bytes)
LONG RAW: Variable length binary string (Maximum size 2GB)
2. NUMERIC Datatype:
NUMBER:
It stores Numeric values and performs numeric calculations.
NUMBER, NUMBER(n), NUMBER(p,s)
It stores Numbers up to 38 digits of precision.
SeqNo NUMBER; 1, 123, 12345678
EmpID NUMBER(4); 1, 123, 1234
Sal NUMBER(7,2); 23456.78 , 123.45 — correction in video: Sal NUMBER(a7,2); which is wrong please ignore.
1234567 can be a type of NUMBER, NUMBER(7), NUMBER(7,0)
It can store both integer and floating point numbers
NUMERIC(p,s)
FLOAT: Ex: EmpSal FLOAT; FLOAT(7) Decimal Points allowed
DEC(p,s), DECIMAL(p,s) , REAL, DOUBLE PRECISION
INTEGER: Ex: SSN INTEGER; Decimal Points are not allowed
INT, SMALLINT
3. DATE Datatype:
DATE:
It stores DATE(Date, Month, Year) and Time(Hour, Minute, Second, AM/PM) and performs calculations with such data.
Default DATE format in Oracle is “DD-MON-YY”
Based on "Gregorian calendar" where the date ranges from “JAN 1 4712 BC” to “DEC 31 9999 AD”
doj DATE; “18-MAR-2010 12:30:00 PM”
TIMESTAMP: It can store all parameters as DATE datatype and additionally it can have “Fraction of seconds” and
TIMESTAMP WITH TIMEZONE / TIMESTAMP WITHOUT TIMEZONE.
Range from 0-9 digits, the default size is 6.
4. LOB Datatype:
LOB: “Large Object” data.
It can store pictures, motion pictures, Textfiles etc.
CLOB: “Character Large Object” is used to store structured information like a text file with a specific file format.
BLOB: “Binary Large Object” is used to store Un-structured information like Image, JPEG files, MPEG files etc.
BFILE: “Binary File” is used to store the pointer to a specific file / Just store the location of a file.
Maximum size: (4 GB - 1) * DB_BLOCK_SIZE initialization parameter (8 TB to 128 TB)
Extra Information:
NCLOB : It supports all the character set supported by CLOB and additionally it handles NLS(National Language Support )
Maximum size: (4 GB - 1) * DB_BLOCK_SIZE initialization parameter (8 TB to 128 TB)
ROWID and UROWID(optional size) Datatype: contains fixed length Binary data.
BBBBBBB.RRRR.FFFFF combination of BLOCK-ROW-DATABASE FILE
Physical and Logical ROWID
Upcoming Session:
Session 7:
Populating Data into Tables(INSERT Statement):
Inserting data into all columns of a table
Inserting data into Required columns of a table
Inserting NULL value into a table
Inserting Special Values(USER / SYSDATE) into a table
Supplying data at runtime(using & and &&)
THANK YOU :)

Views: 232
Prabhat Sahu

Check out my Blog:
http://exceltraining101.blogspot.com
When you want to remove decimal numbers and not be bothered with rounding there are two functions that can do that: INT and TRUNC. This video gives you a quick example on how it's done.
Feel free to provide a comment or share it with a friend! --------------------------------------- #exceltips
#exceltipsandtricks
#exceltutorial
#doughexcel #exceltips
#exceltipsandtricks
#exceltutorial
#doughexcel #exceltips
#exceltipsandtricks
#exceltutorial
#doughexcel #exceltips
#exceltipsandtricks
#exceltutorial
#doughexcel #exceltips
#exceltipsandtricks
#exceltutorial
#doughexcel

Views: 10345
Doug H

How to round numbers in Java.
here the code:
double R=83.13532213;
R=Math.round(R*100.0)/100.0;
System.out.print(" 83.13532213 to 2 digits"+R);

Views: 22892
DeeDoOo toys

How to use concatenation operator, to_char, currency symbol, display money

Views: 1250
Gaivota OracleSQL Lessons

In a previous video (https://www.youtube.com/watch?v=o_Qh0SccyAc) I showed you how to write natural language narratives in Power BI.
In this video I will show you how to format decimal numbers inside your natural language text.
Looking for a download file? Go to our Download Center: https://curbal.com/donwload-center
SUBSCRIBE to learn more about Power and Excel BI!
https://www.youtube.com/channel/UCJ7UhloHSA4wAqPzyi6TOkw?sub_confirmation=1
Our PLAYLISTS:
- Join our DAX Fridays! Series: https://goo.gl/FtUWUX
- Power BI dashboards for beginners: https://goo.gl/9YzyDP
- Power BI Tips & Tricks: https://goo.gl/H6kUbP
- Power Bi and Google Analytics: https://goo.gl/ZNsY8l
ABOUT CURBAL:
Website: http://www.curbal.com
Contact us: http://www.curbal.com/contact
▼▼▼▼▼▼▼▼▼▼
If you feel that any of the videos, downloads, blog posts that I have created have been useful to you and you want to help me keep on going, here you can do a small donation to support my work and keep the channel running:
https://curbal.com/product/sponsor-me
Many thanks in advance!
▲▲▲▲▲▲▲▲▲▲
QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
► Twitter: @curbalen, @ruthpozuelo
► Google +: https://goo.gl/rvIBDP
► Facebook: https://goo.gl/bME2sB
#POWERBITIPS #CURBAL #POWERBI #MVP
► Linkedin: https://goo.gl/3VW6Ky

Views: 4943
Curbal

In this video we will learn, converting one data type to another using cast() and convert() functions. We will also learn how to use the style parameter, with convert() function. Finally we will look at a practical example of using CAST or CONVERT functions, along with group by. We will also talk about the differences between CAST and CONVERT functions and when to choose one over the other.
Text version of the video
http://csharp-video-tutorials.blogspot.com/2012/09/cast-and-convert-functions-in-sql.html
Slides
http://csharp-video-tutorials.blogspot.com/2013/08/part-28-cast-and-convert-functions.html
All SQL Server Text Articles
http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html
All SQL Server Slides
http://csharp-video-tutorials.blogspot.com/p/sql-server.html
All Dot Net and SQL Server Tutorials in English
https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd
All Dot Net and SQL Server Tutorials in Arabic
https://www.youtube.com/c/KudvenkatArabic/playlists

Views: 183640
kudvenkat

In this video I take a look at the structure of tables I plan on using for my database and point on the relational links between the tables. I also discuss the primary key of the table as well as using it as a foreign key in a related table. I take a look at a few basic data types for field columns to include:
CHAR = 255 characters
VARCHAR = 255 characters
SMALLINT = -32,768 to 32,767
INT = -2,147,483,648 to 2,147,483,647
DECIMAL = Numbers with a decimal value
Date = In the format DD-MMM-YYYY
This video is part of a series of videos with the purpose of learning the SQL language. For more information visit Lecture Snippets at http://lecturesnippets.com.

Views: 18197
Lecture Snippets

How can we represent negative numbers in binary? There are several ways. This video compares using a sign bit, ones complement, and twos complement. Twos complement is the most commonly technique because it's relatively easy to implement in hardware and it makes addition and subtraction with negative numbers easy.
Support me on Patreon: https://www.patreon.com/beneater

Views: 318208
Ben Eater

The UPDATE SQL statement is used to make changes to data in a database. You can make changes to one more columns for multiple rows in a single query. Today we will work an elite database of internationally known spies to practice making UPDATEs and checking our work.
Our SQL playlist starts here:
↪http://bit.ly/Socratica_SQL
Be sure to SUBSCRIBE for more SQL!
↪ http://bit.ly/SocraticaSubscribe
You may also enjoy our Python playlist:
↪http://bit.ly/PythonSocratica
———————————————
»» To help us make videos more quickly, you can support Socratica at:
… Patreon: https://www.patreon.com/socratica
… Paypal: https://www.paypal.me/socratica
… Bitcoin: 1EttYyGwJmpy9bLY2UcmEqMJuBfaZ1HdG9
Thank you!!
———————————————
»» You can also follow Socratica on:
... Twitter: @socratica
… Instagram: @SocraticaStudios
… Facebook: @SocraticaStudios
———————————————
SQL instructor: Ulka Simone Mohanty (@ulkam on Twitter)
Written & Produced by Kimberly Hatch Harrison (@khhsocratica) & Michael Harrison (@mlh496)

Views: 4213
Socratica

This tutorial will show you how recognise if a number field needs to be set to 1 decimal place

Views: 14548
BosworthA2ICT

This video gives an introduction to UTF-8 and Unicode. It gives a detail description of UTF-8 and how to encode in UTF-8. This is a video presentation of the article "How about Unicode and UTF-8" which was published on www.gamedev.net.
Writing an STL-Style UTF-8 String Class -
http://squaredprogramming.blogspot.com/2013/12/writing-stl-style-utf-8-string-class.html
How about Unicode and UTF-8 - http://www.gamedev.net/page/resources/_/technical/general-programming/how-about-unicode-and-utf-8-r3322
www.squaredprogramming.com

Views: 149987
Squared Programming

Next up on our MySQL to-do list is to learn about storing dates and times. There are various data types in MySQL for storing dates and times. It seems MySQL and databases likes to break everything up into multiple data types to make things more organized at the consequence of being confusing and annoying.
This video is going to be talking about the DATETIME, DATE, and TIME data types. These are all used to store, you guessed it, dates and times. The one you choose depends on your needs. If you just need dates, choose DATE. If you just need times, choose TIME, if you need both stored together, choose DATETIME.
Now you set a column one of these data types whenever you want every row for this field to have some sort of date, time or both…but how exactly is the data formatted? This requires us to understand some convention. For example, in the USA at least, if you have something like 4:30AM, by convention you know the hour is 4 and the minutes are 30. But this is just an agreed upon convention. MySQL has its own convention…For example 2017-02-02. The first thing is the year, the second is the month, and the third is the day. That is for the DATE. The convention for time is 22:54:30. The first is the hour (military time), the second is the minute, and the third is the seconds. Lastly, there can actually be fractions of seconds…up to microseconds! .123456. To use fractional seconds though you must specify to MySQL the precision of the TIME or DATETIME when you create it, for example DATETIME(6) would allow microsecond precision.
How do you actually give a date to MySQL? By that I mean let's say you have a table with a column of DATETIME(6), and you want to give a value for that column, how do you format it? It's quoted. For example:
'2017-02-02 22:54:30.333333'
MySQL interprets this as a DATETIME.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Support me! http://www.patreon.com/calebcurry
Subscribe to my newsletter: http://bit.ly/JoinCCNewsletter
Donate!: http://bit.ly/DonateCTVM2.
~~~~~~~~~~~~~~~Additional Links~~~~~~~~~~~~~~~
More content: http://CalebCurry.com
Facebook: http://www.facebook.com/CalebTheVideoMaker
Google+: https://plus.google.com/+CalebTheVideoMaker2
Twitter: http://twitter.com/calebCurry
Amazing Web Hosting - http://bit.ly/ccbluehost (The best web hosting for a cheap price!)

Views: 36914
Caleb Curry

Check out my Blog:
http://exceltraining101.blogspot.com
This video covers how to convert or change text to numbers using several methods. Also how to convert or change numbers to text using some different methods.
#exceltips
#exceltipsandtricks
#exceltutorial
#doughexcel

Views: 422379
Doug H

Make your life easy with formatted strings. This video goes over how to use them to print out to the screen and how to store them in a variable.
| Learn more: docs
https://docs.oracle.com/javase/tutorial/essential/io/formatting.html
| Language
Java (.java /.class)
| Code Example
https://github.com/simply-coded/Java-Tutorials
| Support
https://www.paypal.me/JeremyE

Views: 3968
SimplyCoded

How to Determine if value is Numeric by using ISNumeric and Try_Convert Function in SQL Server - TSQL Tutorial
ISNUMERIC( ) function is provided to us in SQL Server to check if the expression is valid numeric type or not. As per Microsoft it should work with Integers and Decimal data types and if data is valid integer or decimal, ISNumeric() should return us 1 else 0. But ISNUMERIC() does not work as expected with some of values specially when we have "-" or "d" in value and have two numbers after "d" such as 123d22, it still return us 1. Also if we have data in money format $XXXXX e.g $2000, It returns us 1.
In SQL Server 2012. Microsoft introduced new function call Try_Convert( ). You can use try_convert function to convert to required data type and if it is not able to convert then it will return Null as output. As you will see below, I did some experiment and found out that Try_Convert will produce 0 for "-" when we try to convert to Int, That should not be happening as "-" is symbol not Integer. But when I try to convert "-" to decimal, Try_Convert produced Null output.
Take a look in below results and keep in mind the outputs when you have to evaluate expression to Numeric or find out if expression is Numeric or Not.
Blog post link for this video
http://sqlage.blogspot.com/2015/03/how-to-determine-if-value-is-numeric-by.html

Views: 3637
TechBrothersIT

Common function to check and allow multiple formats in a textbox for date field.

Views: 46
Oracle Forms

In the previous video we talked about some of the most popular data types. We are going to discuss them in more detail. The data type we are going to start with is CHAR and NCHAR. I told you of both of these but I never explained the difference. That's because there is some other stuff I need to explain before I can explain the difference. This has to deal with what is known as character sets.
When you have a string, there are only so many characters you are allowed to store in that string. The characters you are allowed to store is determined by what is known as the character set.
A common character set is ASCII. This character set allows you to store English characters, numbers, and some symbols. ASCII started with 127 characters, and then they came out with the ASCII extended, which allows for up to 255 characters. Even with 255 characters though, we are limited in what we can store using one character set. If the computer only allows ASCII, we are going to be limited when working with different languages. Of course it works for some situations, but globalization of software has been a big thing with the development of the interwebs …and the movement towards a new world order (Revelation 13:7).
That means that ASCII is no longer the best character set. It has largely been replaced with a character set known as Unicode. Oracle has a few Unicode character sets that we can use when we work with string data.
When you start studying character sets, I can promise that you will run across the word encoding. Encoding refers to the way that the allowed characters can be stored on the computer. A computer doesn't just store a letter, everything has to be stored in binary. Unicode is the character set, but it has numerous different encodings. Essentially, the computer can store the same characters in multiple different ways, depending on which encoding is used.
The most popular encodings for Unicode are UTF-8 and UTF-16. UTF stands for Unicode Transformation Format. In the next video we will be discussing these in detail and express their differences. Once we got that down, we'll be able to loop back around to data types.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Support me! http://www.patreon.com/calebcurry
Subscribe to my newsletter: http://bit.ly/JoinCCNewsletter
Donate!: http://bit.ly/DonateCTVM2.
~~~~~~~~~~~~~~~Additional Links~~~~~~~~~~~~~~~
More content: http://CalebCurry.com
Facebook: http://www.facebook.com/CalebTheVideoMaker
Google+: https://plus.google.com/+CalebTheVideoMaker2
Twitter: http://twitter.com/calebCurry
Amazing Web Hosting - http://bit.ly/ccbluehost (The best web hosting for a cheap price!)

Views: 6073
Caleb Curry

How to convert Julian days into dates in excel
In this video I show how to change the cell formatting in excel and use custom formatting to show Julian days as date and time.
Julian days are simply a continuous count of days and fractions instead of dates. They were originally called Julian days because they came from the Julian calendar and started on noon Universal Time on January 1, 4713 BC. However the name is now used for other continuous counts of days. For example day one in excel is 01/01/1900.
#exceltutorial #excelformatting #exceltipsandtricks
Subscribe: https://goo.gl/c46YPs
If you like this video you may also like 'How to convert excel dates into decimal dates' https://youtu.be/GjYJ-oTBlP0
The data is related to my university dissertation

Views: 5607
Karina Adcock

The first category of data types that we are going to cover in this MySQL series are the string data types, or character data types. There are two that I am going to talk about in this video, CHAR and VARCHAR. We'll start with CHAR.
CHAR is a string data type where you specify how many characters are allowed in parenthesis after you declare the column as this type.
For example, we can say CHAR(50) to allow up to 50 characters for each value in that column.
The thing to know about CHAR though is that it is a fixed-length string. That means every single value inside of that column is actually going to be whatever you declare the length as. So if you say CHAR(50), every string is going to be 50 characters long. If, for example, you have a row that only uses 40 characters, MySQL will pad the right side of the string with spaces until it fills 50 characters.
Now, the highest value you can put in here is 255. The 255 refers to characters. This means that you can have strings with up to 255 characters. How does the computer know how to store these characters? That has to deal with the character set and the encoding of the characters. By default, MySQL is going to use UTF-8. We are not going to discuss UTF-8 in detail for a while but essentially UTF-8 says that each character can take up to 3 bytes of storage.
255 comes from the max number you can count to using binary. So if we are keeping track of how many values are in this column in an 8 bit number, 255 is the highest. If you don't know what I'm talking about it, we'll worry about it later.
You can actually make the column CHAR(0). In this situation, the only thing you could put in as a value for this column is an empty string ('').
When retrieving variable length CHAR data from a database it may not look like the database pads the value. That's because MySQL actually strips spaces from the value when presented. If you want to keep all of the spaces that have been added when you retrieve the value, you can do that. Look up PAD_CHAR_TO_FULL_LENGTH online.
In the next video we are going to discuss VARCHAR.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Support me! http://www.patreon.com/calebcurry
Subscribe to my newsletter: http://bit.ly/JoinCCNewsletter
Donate!: http://bit.ly/DonateCTVM2.
~~~~~~~~~~~~~~~Additional Links~~~~~~~~~~~~~~~
More content: http://CalebCurry.com
Facebook: http://www.facebook.com/CalebTheVideoMaker
Google+: https://plus.google.com/+CalebTheVideoMaker2
Twitter: http://twitter.com/calebCurry
Amazing Web Hosting - http://bit.ly/ccbluehost (The best web hosting for a cheap price!)

Views: 4870
Caleb Curry

If you have an average value , how to round it up to 2 / more decimal places .
1. You don't always have to typecast it to numeric either . You can just say round(avg(salary),2) as well . While converting to a numeric datatype does make sense , it is not always required .
2. small change : at 0:44 , I refer to using job title and salary as the main columns , that is inaccurate . We will be using department and salary as the main columns .
Hope this helps . Thanks !

Views: 721
saurabh rao

A common problem in the database world is when we persist in putting numeric data into a string datatype...and then expect to sequence the data in numeric fashion.
This quick tip looks at how to handle it, and covers an interesting AskTom question at the same time.
======================================================
Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.

Views: 685
Connor McDonald

http://www.bitsinfotec.in/
previous lectures doubt solved and implicit conversion in functions
function in plsql

Views: 375
JavaTreePoint

Data conversion is the conversion of computer data from one format to another. Throughout a computer environment, data is encoded in a variety of ways. ... Similarly, the operating system is predicated on certain standards for data and file handling. Furthermore, each computer program handles data in a different manner.
Binary to Decimal
Decimal to Binary, Octal, Hexadecimal
A systematic method for number conversion
Binary to Octal
Octal to Binary
Binary to Hexadecimal
Hexadecimal to Binary
Number System Conversion
Numeral Systems - Binary, Octal, Decimal, Hex
Number System and base conversions
Converting Between Binary, Octal, Decimal, and Hexadecimal
Number Systems - Converting Decimal, Binary and Hexadecimal
Conversion between number systems
Latest Videos:
-----------------------------------------------------------------------------------------------------------
https://www.youtube.com/edit?o=U&vide...
https://www.youtube.com/watch?v=qj6QAT_IprA
-----------------------------------------------------------------------------------------------------------
PLEASE LIKE , COMMENT AND SUBSCRIBE FOR MORE VIDEOS.

Views: 91
Learn with Khalil

Data Types in SQL Server
CORRECTION: for storing DECIMAL you need to just count the numbers in precision and scale, like to store 100.55 you have to define like DECIMAL(5,2)
Check my blog for more details and SQL Queries: https://sqlwithmanoj.com/2015/09/20/sql-basics-data-types-in-sql-server-video/
For more updates like my page in FB: https://www.facebook.com/sqlwithmanoj

Views: 30904
SQL with Manoj

This tutorial explains the utf-8 way of representing characters in a computer; later generalizing (high level) how any kind of data can be represented in a computer.

Views: 44021
dizauvi

How to prevent Excel rounding large numbers and showing it in scientific Notation E+ exponential
How To Convert Scientific Notation To Text Or Number In Excel?
Convert scientific notation to normal numbers:

Views: 77
ramit girdhar

Oracle Java Certification: Shortest Way To Crack OCA 1Z0-808 Just @ Rs 640/-
--------------------------------------------------------------------------------------------------------
1. For Java SE 8 Programmer I Exam
2. Topic wise Tests and Grand Tests
3. 280 Realistic Questions With Clear Explanation
4. Study Material (408 Pages)
5. Question Bank (107 Pages)
6. Videos (63 Sessions)
Use the below links to access Durga Sir Videos and Downloadable Materials and Topic wise Tests and Grand Tests with Life-Time Access.
1. Oracle Java Certification: Shortest Way To Crack OCA 1Z0-808
Link: https://goo.gl/vcMKjz
2. Java 8 New Features In Simple Way
Link: https://goo.gl/F2NfZi
3. Java 9 New Features In Simple Way: JShell, JPMS and More
Link: https://goo.gl/s9PP1p
4. Complete JDBC Programming Part-1
Link: https://goo.gl/uT9sav
5. Complete JDBC Programming Part-2
Link: https://goo.gl/VmhM7t

Views: 548
Durga Software Solutions

Use the type conversion functions to change the type of an argument.
StringToDate
Returns a date from the given string in the given format. You do not have to specify a format string if your string contains a date in the default format yyyy-mm-dd.
Input: string (string) [,format (string)]
Output: result (date)
Examples: If the column mylink.mystring contains the string ″1958--08--18″, then the following function returns the date 1958--08--18.
StringToDate(mylink.mystring)
If the column mylink.mystring contains the string ″18:08:1958″, then the following function returns the date 1958--08--18.
StringToDate(mylink.mystring,"%dd:%mm:%yyyy")

Views: 5949
WingsOfTechnology

In this video ,we will generate the script that will return us all the table names with column names and data type of those columns. We often need this information. Let's say we are going to prepare mapping document for load the data from Source Database to Destination database. We can get the list of all tables with column names and data types from Source Database and Destination Database and then paste in Excel and map the required input columns to output columns for ETL Process.
Blog link with scripts used in video
http://sqlage.blogspot.com/2015/02/get-all-tables-with-column-names-and.html

Views: 49647
TechBrothersIT

This video show a couple of example of the use of the FORMAT function in SQL Server. This function is very useful, but many people do not know exists in TSQL.

Views: 140
Coopman Greg

This video explains how to format currency in ssrs reports.
Please let me know your thoughts via comments

Views: 3044
dnanetwork

C Program #8: Decimal to Binary Conversion......
Thanks for Watching my Channel “Learn TechToTech”. Please subscribe my channel for getting first updates after uploading video.Social Media pages of Channel are:
1. My Website : www.learnfromrakesh.com
2. My Twitter: https://twitter.com/LearnTechtotech
3. Facebook Page: https://www.facebook.com/LearnTechToTech
4. Blogger : https://learntechtotech.blogspot.in/
5. Google+ : https://learntechtotech.blogspot.in/
6. Pinterest : https://in.pinterest.com/LearnTechToTech/
7. LinkedIn: https://www.linkedin.com/in/Learntechtotech/
Playlist of Different Technology:
1. Operating System : https://goo.gl/q6SfrW
2. Python Programming Language : https://goo.gl/L8b5dc
3. C Language : https://goo.gl/SwvDu9
4. C language for Placement: https://goo.gl/AaQBa4
5. Java: https://goo.gl/M8F2uy
6. MySql : https://goo.gl/vdJbHQ
7. Android Mobile Application Development: https://goo.gl/M6woaT
8. Kotlin Programming Language : https://goo.gl/GXE5cd
9. Go Programming: https://goo.gl/Ua3xYW
10. Internet of Things(IoT): https://goo.gl/f2afkY
11. Oracle 11g : https://goo.gl/zds8r2
12. C++ : https://goo.gl/C1psMT
13. R Programming: https://goo.gl/6pDrsb

Views: 120
Learn TechToTech

Truncate Numbers In Excel
Watch more videos for more knowledge
How to Truncate Excel 2007 Data - YouTube https://www.youtube.com/watch/-2mHaMD_tCM
Excel Trunc Function Tutorial - YouTube https://www.youtube.com/watch/LOqMKliIYGU
Rounding and truncating No. 1 in Microsoft Excel ... https://www.youtube.com/watch/hT-P6TzvCtw
Cutting numbers off using the TRUNC function in ... https://www.youtube.com/watch/6Mtw9pLTgLE
Decimal Places How To Round Numbers In Excel ... https://www.youtube.com/watch/ux_7pZdQFfs
How to truncate cell value in excel - YouTube https://www.youtube.com/watch/EahdAAAPGn0
Fix: Excel truncating 16 digit numbers - YouTube https://www.youtube.com/watch/xAVbBXMOuiE
How to use the TRUNCATE Function in MS Excel ... https://www.youtube.com/watch/ICIzRKmufDY
How to Trim or Remove Text in Excel - YouTube https://www.youtube.com/watch/e3id-5YcRgM
Excel 2013 Tutorial#66 TRUNC Function in Excel ... https://www.youtube.com/watch/Eh6_ZaV-VMU
How To Truncate Number OR Text String In Excel ... https://www.youtube.com/watch/TfcJhj4xIWo
EXCEL - FUNCTIONS TRUNC TRIM AND VALUE ... https://www.youtube.com/watch/M3X_urc2vqo
Excel Trick - How To Remove Selected Digit From ... https://www.youtube.com/watch/kDmOu1J3tk8
Microsoft Excel - Truncate a string of text in a cell ... https://www.youtube.com/watch/gYMytk5n1zw
Rounding Numbers and Removing Decimals in ... https://www.youtube.com/watch/6glTBUBE7EU
Excel TRUNC Function - How to use TRUNC ... https://www.youtube.com/watch/xBDmBZthmoY
How to Drop Decimal Places Without Rounding in ... https://www.youtube.com/watch/qBgoTgHKpFU
How to Format Excel Number in Thousands - YouTube https://www.youtube.com/watch/d-PqtG9IBB0
Excel magic trick 29 bangla - ROUND & TRUNC ... https://www.youtube.com/watch/YUQMU2MRj0M
OpenOffice Calc 4 Tutorial 7 - Rounding And ... https://www.youtube.com/watch/1WdeuCEZyCk

Views: 8
crazy sparky

A question from my Nashville Power Excel seminar: How to deal with downloaded data where some cells contain trailing minus numbers?
It is tempting to fix them manually or to use =IF(RIGHT(B2,1)="-",-1*LEFT(B2,LEN(B2)-1),B2)
Text to Columns is a fast way to deal with this
Choose the whole column
Data, Text to Columns, Delimited, Next, Make sure there are no lines, Next, Options: Trailing Minus
In fact, since Trailing Minus is the default, there is a faster way: Select whole column and Alt+D E F
To download this workbook: https://www.mrexcel.com/download-center/2018/05/some-trailing-minus-numbers.xlsx
List of upcoming seminars: https://www.mrexcel.com/press-appearances/

Views: 1039
MrExcel.com

Beyond basic arithmetic, some programs require more complex math operations. The Java Math class has many methods you can call to do just that! Refer to the Java API for a full list of Math methods:
https://docs.oracle.com/javase/8/docs/api/java/lang/Math.html
Please SUBSCRIBE to Appficial, and check out more Java Programming Tutorials! http://www.appficial.com
The Basic Parts of a Java Program - Class and Main Method Header and Comments
https://youtu.be/sHEk2DSBnSg
Java Declaring and Initializing Variables
https://youtu.be/Ag8ZH5qRzqM
Naming Java Identifiers - Variables, Methods, and Object Names - Java Tutorial
https://youtu.be/g0NR6Z0ac1A
Java Reserved Keywords - Words like public static void class int double
https://youtu.be/dklOXLDdeqc
Java Primitive Data Types - byte short int long float double char and boolean
https://youtu.be/hHTrxfEWPy0
Java Integers - int long byte and short Integer Variables
https://youtu.be/FsrIsDSgTiQ
Java Floating Point Numbers - float and double
https://youtu.be/6JRufRrO1mQ
Java E Notation - Doing Scientific Notation in a Java Program
https://youtu.be/9tTKa9jEgNs
Java Integer Division and Dividing by Zero - Java Tutorial - Appficial
https://youtu.be/46Ngr6eczpA
Java Basic Math Arithmetic Expressions and Precedence Rules
https://youtu.be/IMavhbsbIeQ
Java Compound Operators - Combined Assignment Arithmetic Operator Examples
https://youtu.be/2TP7XOyCW1o
Java Constants - Constant Variables using Keyword Final
https://youtu.be/cj_5D8-vrfQ
Java Math Class Methods
https://youtu.be/Guhb43pivCs
Java Type Conversions and Type Casting
https://youtu.be/hXxFVXBxQ1Q
How to Convert Binary numbers to Decimal Numbers
https://youtu.be/g1TOLO2FsvQ
Java Characters - The char Primitive Data Type
https://youtu.be/LBQrD2nkKQg
Java Escape Characters
https://youtu.be/jZpSjEGMlUQ
Java String Class
https://youtu.be/3G9IcmbV4Gs
Java Scanner Class
https://youtu.be/A1QXB_6ALDA
Java Integer Overflow
https://youtu.be/lTnUbx5Gi6o
Java Style Guidelines
https://youtu.be/P7xur0m6-do

Views: 634
Appficial

Views: 116
Shri Ram Programming Academy

Happy belated Pi Day once more! Here I attempt to approximate Pi using a special location in the Mandelbrot set. The programming environment is Processing (Java).
💻 https://thecodingtrain.com/CodingChallenges/141-mandelbrot-pi
🔗 The World of Pi: http://www.pi314.net/eng/
🔗 BigDecimal: https://docs.oracle.com/javase/7/docs/api/java/math/BigDecimal.html
🔗 Mandelbrot Image:
Created by Wolfgang Beyer with the program Ultra Fractal 3. - Own work: https://en.wikipedia.org/wiki/Mandelbrot_set#/media/File:Mandel_zoom_00_mandelbrot_set.jpg
🎥 Mandelbrot Set with p5.js: https://youtu.be/6z7GQewK-Ks
🎥 Fourier Series: https://youtu.be/Mm2eYfj0SgA
🎥 Pi and the Mandelbrot Set - Numberphile: https://youtu.be/d0vY0CKYhPY
🎥 Calculating Digits of Pi with Collisions: https://youtu.be/PoW8g67XNxA
🎥 12 Hour Live Stream (last 4 hours sadly cut-off): https://youtu.be/PIeKyP97EUc
🚂 Website: http://thecodingtrain.com/
💖 Patreon: https://patreon.com/codingtrain
🛒 Store: https://www.designbyhumans.com/shop/codingtrain/
📚 Books: https://www.amazon.com/shop/thecodingtrain
🎥 Coding Challenges: https://www.youtube.com/playlist?list=PLRqwX-V7Uu6ZiZxtDDRCi6uhfTH4FilpH
🎥 Intro to Programming: https://www.youtube.com/playlist?list=PLRqwX-V7Uu6Zy51Q-x9tMWIv9cueOFTFA
🔗 p5.js: https://p5js.org
🔗 Processing: https://processing.org

Views: 25516
The Coding Train

Updated Video showing an easier way check out:
https://youtu.be/QzNxFah1jjM
Download Free Excel Cheatsheet at: https://www.computertutoring.co.uk/free-cheatsheets.asp
European currency formats have the decimals in place of the commas and commas in place of the decimals:
European: EUR 3.847.88
UK: £3,847.88
This video shows how to use the substitute function to covert.
More tutorials can be found at https://www.computertutoring.co.uk/

Views: 19523
Computer Tutoring

How I like to format SQL statements in order to be quickly and easily read and understood.

Views: 1247
Daniel Meyer

This video explains what an alphanumeric outline is and how it works, then shows you how to build a strong one.

Views: 5305
Michael Andrews Bashan