dbWriter Home
IP to Country Look up
Site Map

IP to Country DB

Free Databases:

ASP Code

ASP Links

VB Script functions:
Array
Case/Select
In String (inStr)
Replace

HTML code:
SELECT Color
SELECT Countries
SELECT Language
SELECT State/Province

SQL:

SQL Functions:
Delete leading Char
Get Browser
Long number from IP

Stored Procedures:

SQL Tricks:
Delete ALL duplicates
Delete dup records

MISC
IP Address Owner
MS SQL Server

Mortgage Calcs:
how much is my payment
Loan Amortization
Loan Calculator
Mortgage Calculator
Motrgage Pay Off

dbWriter License

Link to US

Links

Contact US
 

dbWriter Date/Time Function ASP code

Format date and time or remove seconds from time.

<%
Private Function Format(byVal theInput, byVal strFormat)
On Error Resume Next

Select Case lcase( strFormat )
Case "general date"
Format = FormatDateTime(theInput, 0)
Case "long date"
Format = FormatDateTime(theInput, 1)
Case "short date"
Format = FormatDateTime(theInput, 2)
Case "long time"
Format = FormatDateTime(theInput, 3)
Case "short time"
Format = FormatDateTime(theInput, 4)
Case "time no seconds"
Dim DT
Dim TimePart
Dim AMPMPart
DT = TimeValue(theInput)
TimePart = Left(DT, Len(DT) - 6)
AMPMPart = Right(DT, 2)
Format = TimePart & Lcase(AMPMPart)
Case Else
Format = theInput
End Select
On Error GoTo 0
End Function

%>
updated 5/03/07
Partners/Links © 2005 - 2008 dbWriter.com All Rights Reserved
This site is protected by the dbWriter IPtoCountry MS/SQL database!!
Site map | Link to US
Contact Us

Sign up for PayPal and start accepting credit card payments instantly.