A collection of 18 FAQs on Transact-SQL language date and time operations and functions. Clear answers are provided with tutorial exercises on converting date and time values to integers or decimal values; incrementing and decrementing date parts; taking date differences; formatting dates to strings; getting GMT times.

BitWise* is an automated message system, and cannot be added to your contact list. *BitWise* can inform users of different events, such as when they are added as a super buddy, or when someone adds you to their contact list.

Yes, emoticons are planned for inclusion in BitWise. After the release of Version 1 we will be moving the conversations to an HTML format, at which time emoticons will be able to be included, along with additional text formatting options.

During a laparoscopic gall bladder operation, the assistant grasps the gall bladder and the surgeon frees its duct and artery. These are then clipped or tied off and the gall bladder removed from the liver bed. After ensuring that there is no bleeding or injury, the gall bladder including the stones is removed with one of the cannulas. The skin is closed with absorbable sutures. Patient should be able to go home in 12-24 hours after surgery.

Creating BitWise for 3 operating systems requires a large number of tools. Here is a list of the major tools used: BitWise, including the client, server and the website, are written in a variety of languages, including C, C++, Perl, php and mySQL.

Long answer: while we do keep usage numbers, we are not releasing them at this time. From experience, people have a perception of how big BitWise "should be," and when the actual number turns out to be bigger or smaller than expected, certain conclusions are made and/or perceptions change unreasonably about BitWise's service. Therefore, we choose to keep usage statistics out of the public domain at this time.

BitWise Personal is free and may be used only for personal use. BitWise Personal may not be used in any business or for any commercial purpose. Not-for-profit and educational organizations are included in our definition of a business. BitWise Professional may be used for any purpose, business or otherwise. Businesses and other organizations are required to purchase a BitWise Professional Network.

No, viruses cannot be transmitted when casually using BitWise. This is true for one-on-one conversations, conferences, whiteboards or any non-file transfer activity. The only way to get a virus using BitWise would be to actively accept a file transfer from another user and then run the file sent to you. For this reason, we always encourage our users to be cautious when accepting files from others, just like you would be when receiving email attachments.

Because BitWise is only used for transmission of data (not storage of data), our access controls and logs of who is granted what rights (i.e. who has access to use BitWise and thus receive the data) is sufficient for HIPAA in most environments. That is to say, the information being transmitted over BitWise must come from somewhere--which would be your HIPAA-compliant environment; BitWise is only used for transmission, and our transmission encryption and access controls meet HIPAA guidelines.

Your contacts are notified if your encryption keys change or are missing. This can be a head's up to the possibility that your password has been stolen or you are the victim of a man-in-the-middle attack.

Log in to Web Services, and then click on the "Plus" icon. You can pay using a credit card or PayPal and be activated instantly. You can also mail us a check and we will process your membership after receiving your check.

No, just like BitWise Personal, BitWise Plus is meant only for home users. BitWise Professional is required for use in a business, and includes all of the BitWise Plus features. Please see the BitWise Professional Overview for more information.

Absolutely not! BitWise Personal is retaining all of its features, and will continue to receive enhancements in the future. No features were removed from Personal when Plus was released. BitWise Plus adds features that benefit the security-conscious (a.k.a. those with healthy paranoia), and since many users would probably not use the Plus capabilities even if they were available, Personal can hardly be called crippleware.

Themes are available from the Theme forum. We are always interested in accepting new themes if you have one or would like to create one.

The email address associated with your BitWise username can be updated by using the Preferences after logging in to Web Services. Once you enter your new address, you will receive an email that will contain a link for you to follow. After you follow that link, your new email address will be confirmed and entered into your user record.

BitWise has "web bugs" that allow you to display your BitWise status (Online, Away, Offline) from your personal web site; you can even link to a special site that shows your BitWise directory information. You can enable web bugs and get the code you need for your web site by logging in to Web Services and clicking on Preferences.

this time, we are not making any statements regarding inclusion of web cam features. We are monitoring new technologies that will enable such support across all operating systems (Windows, Linux and Mac OS X).

BitWise currently has one simple but challenging game called Conquest. There are no plans to create additional games at this time.

Of course! We do ask that you link only to the main BitWise page, unless you have a specific reason that you need to link to another page.

Click Export to save your preferences to a file. You may place it anywhere, but you will need it again momentarily. Logging settings may not transfer well due to differences in mounting and usage of removable media on different PCs. Windows/Linux: Unzip/untar the file you just downloaded to your thumbDrive. On your drive, you should see a folder named Bitwise. Open the preferences and choose Import and load your preference file that you previously saved on your thumbdrive.

The short answer: BitWise uses encryption on all messages and files sent between you and your contacts; this includes whiteboards, shared file lists, and chat rooms. You can verify the encryption by using a packet sniffer on yourself to watch your network traffic. The long answer: Our white paper Introduction to encryption and how BitWise uses encryption explains in detail how BitWise's encryption works and how the encryption protects and benefits you.

Yes, you can. You need to generate RSA keys using the PKCS #8: Private-Key Information Syntax Standard. Values should be encoded using ASN.1. The keys themselves should be encoded using DER. The following example will generate RSA keys for use with BitWise (these should work on many Linux installations, or Mac OS X; a method for Windows is still under investigation): You can then use BWPriv.pk8 and BWPub.key as your private and public keys, respectively.

You need to be able to establish outgoing connections on ports 4038 and 4039. For optimal performance, you need both incoming and outgoing connectivity on port 4137. You may not change the ports that BitWise uses. Allowing different ports would substantially detract from the ease of communication among BitWise users.

It is too early to give a precise answer to this question as the above question depends on the number of applications submitted. Based on the INTERREG IIIC experience, the approval procedure may take around four to six months from the date of submission of the proposals. The Monitoring Committee may approve the first projects by May/June 2008. Therefore, projects should be ready to start implementation in summer 2008.

There are three answers to this question. First, BitWise is different because it is not supported by advertising or spyware. When using BitWise, whether the program itself, the website, or the forums, there are no distracting ads. Along with this comes an increased privacy--BitWise doesn't need any information about you to target ads to you. Secondly, BitWise is committed to providing high-quality software. Software quality has declined rapidly in the past few years, which is unacceptable to us.

When you downloaded BitWise, a set of sounds was included. The Windows installer version automatically finds and selects the sounds for you; non-installer downloads of BitWise come with a sounds folder that you may place in a location of your choosing.

Absolutely! BitWise actually uses two IP addresses, the server's perception of your IP address, and your PC's perception of its IP address. What this means is that the server can identify all the clients that have the same external IP (such as behind a common router), and can then pass that information to the other clients behind that same router. This will allow the clients behind that common router to communicate seamlessly with each other, as well as the other BitWise clients.

No, BitWise does not offer a pure direct to IP mode. The reasons for this are many, but the most important is that it would be difficult to incorporate it into the program without making the program needlessly more complex. Further, without being able to use the server for authentication, there would be no way to validate users as they "log in" and therefore the username system (and the reasonable assurance of who is on the other end) would be useless and unreliable.

When you click the Undo toolbar button or select Undo from the spreadsheet Edit pull-down menu, you will be able to undo most operations such as editing, moving or copying blocks, random fill, recoding or ranking variables, etc. Multi-level undo is supported (with 16 buffers), so you can undo up to 16 of the most recent spreadsheet operations. When you are overwriting an existing data file (while performing the Save As..