Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 How to convert bytes in GB in SQL?

Author  Topic 

Mathias
Posting Yak Master

119 Posts

Posted - 2007-10-26 : 05:35:44
INFO: 35,393,282,048 bytes free on "L:\" volume.

Kristen
Test

22859 Posts

Posted - 2007-10-26 : 05:50:48
Convert from what to what?

For example: From text with comma to bigint ??
Go to Top of Page

Mathias
Posting Yak Master

119 Posts

Posted - 2007-10-26 : 05:54:51
Convert from bigint to decimal(18,2) where decimal(18,2) is the converted value in Gigabites
Go to Top of Page

Mathias
Posting Yak Master

119 Posts

Posted - 2007-10-26 : 06:11:19
1 Byte = 8 Bit
1 Kilobyte = 1024 Bytes
1 Megabyte = 1048576 Bytes
1 Gigabyte = 1073741824 Bytes
I found it.
Go to Top of Page
   

- Advertisement -