In Feburary 2016 23,
Create a new query statement in SQL to extract a date from the database. However, instead of extracting the raw data value stored in the database, use the 'Date_Format' command in conjunction with the query to ensure the extracted date is in your desired format.
Enter the name of the database variable that represents the raw date value as the first parameter in the 'Date_Format' command. This command uses two parameters separated by a comma inside the command's parenthesis. The format is 'Date_Format(date, format)'.
Identify the SQL date format codes that represent the many date formats that SQL may output. These codes cover all conceivable date formats and may be arranged in any order. Each code begins with a percent sign and is followed by a letter which represents a portion of a date displayed in a particular fashion. For example, '%Y' is the four-digit year, while '%y' is the two-digit year.
Format the second parameter of the 'Date_Format' command using SQL date codes to match the desired output format of the date that is extracted from the database. For example, to create a verbose text output of the date, use '%W, %M %e, %Y'. This date format will appear as 'Sunday, April 18, 2010'. Commas are entered in the format where they should appear in the final output.
Format the date as a numerical string by typing 'Date_Format([date],'%e-%c-%Y')'. Note that the single quotes are not included in the actual typed SQL query. Use the actual name of the database variable for '[date]' in this example. The output will resemble '18-4-2010'.
In Feburary 2016 23,
Showing posts with label desired. Show all posts
Showing posts with label desired. Show all posts
Tuesday, 23 February 2016
Saturday, 20 February 2016
How to Use Dropbox on a MacIn Feburary 2016 20,
In Feburary 2016 20,
Navigate to the Dropbox website (dropbox.com). Click the 'Download Dropbox' button. Dropbox will automatically detect that you are on Mac OS X and direct you to the proper download link.
Double-click the disk icon to mount if it doesn't mount automatically. Drag the Dropbox application icon and, still holding your mouse, move it to your 'Applications' folder. Release your mouse when you see the green '+' sign.
Navigate to your 'Applications' folder and double-click the Dropbox icon to open the application. Click the 'I don't have a Dropbox account' button and click 'Continue' to create a new account.
Enter your first name, last name, email, desired password and the name of your computer. Click the 'Continue' button.
Select your account type. You can create a free account on Dropbox for 2 GB of storage online. If you invite friends and they join Dropbox, you can an acquire an extra free 250 MB on online storage per friend, up to 8 GB. As of March 2011, paid accounts are available with Dropbox for 50 GB of storage at $9.99 per month or 100 GB of storage for $19.99 per month. Click the 'Continue' button.
Select 'Typical' as your setup type. Use the 'Advanced' setup only if you have experience with Dropbox. Click the 'Continue' button. Click the 'Continue' button again to take a five-step tour of the Dropbox application. Click the 'Skip Tour' button to skip the tour, then click the 'Finish' button. Dropbox creates a shortcut link under the 'Places' heading in the right-side menu of your 'Finder' window for easy and direct access.
Create new folders in your Dropbox or drag and drop files to add them to the existing folders. Your 'Public' and 'Photos' folder are automatically shared, but you can create new folders and share them only with specific people. When you add files or folders to Dropbox, you must wait until you see the green check mark next to the files to confirm that they have been uploaded before attempting to share.
Access application options and settings by using the Dropbox menu in your Finder. The Dropbox menu appears in the top of your Finder window after installation and features the Dropbox logo with a small, gray arrow next to it. The menu lets you share folders and browse them on the Dropbox website.
In Feburary 2016 20,
Navigate to the Dropbox website (dropbox.com). Click the 'Download Dropbox' button. Dropbox will automatically detect that you are on Mac OS X and direct you to the proper download link.
Double-click the disk icon to mount if it doesn't mount automatically. Drag the Dropbox application icon and, still holding your mouse, move it to your 'Applications' folder. Release your mouse when you see the green '+' sign.
Navigate to your 'Applications' folder and double-click the Dropbox icon to open the application. Click the 'I don't have a Dropbox account' button and click 'Continue' to create a new account.
Enter your first name, last name, email, desired password and the name of your computer. Click the 'Continue' button.
Select your account type. You can create a free account on Dropbox for 2 GB of storage online. If you invite friends and they join Dropbox, you can an acquire an extra free 250 MB on online storage per friend, up to 8 GB. As of March 2011, paid accounts are available with Dropbox for 50 GB of storage at $9.99 per month or 100 GB of storage for $19.99 per month. Click the 'Continue' button.
Select 'Typical' as your setup type. Use the 'Advanced' setup only if you have experience with Dropbox. Click the 'Continue' button. Click the 'Continue' button again to take a five-step tour of the Dropbox application. Click the 'Skip Tour' button to skip the tour, then click the 'Finish' button. Dropbox creates a shortcut link under the 'Places' heading in the right-side menu of your 'Finder' window for easy and direct access.
Create new folders in your Dropbox or drag and drop files to add them to the existing folders. Your 'Public' and 'Photos' folder are automatically shared, but you can create new folders and share them only with specific people. When you add files or folders to Dropbox, you must wait until you see the green check mark next to the files to confirm that they have been uploaded before attempting to share.
Access application options and settings by using the Dropbox menu in your Finder. The Dropbox menu appears in the top of your Finder window after installation and features the Dropbox logo with a small, gray arrow next to it. The menu lets you share folders and browse them on the Dropbox website.
In Feburary 2016 20,
Thursday, 4 February 2016
How to Set Up a Router for FilezillaIn Feburary 2016 04,
In Feburary 2016 04,
Open the Filezilla FTP program. Click 'Edit' and select 'Settings.' Click on 'Connection' in the settings hierarchy and select 'Passive Mode.'
Add a check mark to 'Use Custom Port Range' and enter your desired port range. Valid ports can be from 1 to 65535, but users should assign a port range beyond 1024, as ports below that range are often reserved for other protocols.
Log in to your router's configuration page and enter the router's username and password when prompted.
Navigate to the router's 'Port Forwarding' settings page. Enter 'FileZilla' as the application name. Enter the start of the port range created in FileZilla into the 'Start' text field and the end of the port range into the 'End' text field. Set the 'TCP' and 'UDP' settings to 'Both' and add a check mark to the 'Enable' box.
Create another port forwarding entry with the same application name. Enter '20' as the start of the port range and '21' as the end of the range. Set the 'TCP' and 'UDP' settings to 'Both' and add a check mark to the 'Enable' box. Click 'Save Settings' to finalize your changes. Restart your router, if necessary. The ports assigned for FileZilla should remain open for FTP traffic.
In Feburary 2016 04,
Open the Filezilla FTP program. Click 'Edit' and select 'Settings.' Click on 'Connection' in the settings hierarchy and select 'Passive Mode.'
Add a check mark to 'Use Custom Port Range' and enter your desired port range. Valid ports can be from 1 to 65535, but users should assign a port range beyond 1024, as ports below that range are often reserved for other protocols.
Log in to your router's configuration page and enter the router's username and password when prompted.
Navigate to the router's 'Port Forwarding' settings page. Enter 'FileZilla' as the application name. Enter the start of the port range created in FileZilla into the 'Start' text field and the end of the port range into the 'End' text field. Set the 'TCP' and 'UDP' settings to 'Both' and add a check mark to the 'Enable' box.
Create another port forwarding entry with the same application name. Enter '20' as the start of the port range and '21' as the end of the range. Set the 'TCP' and 'UDP' settings to 'Both' and add a check mark to the 'Enable' box. Click 'Save Settings' to finalize your changes. Restart your router, if necessary. The ports assigned for FileZilla should remain open for FTP traffic.
In Feburary 2016 04,
Subscribe to:
Posts (Atom)