Chat now with support
Chat with Support

Benchmark Factory for Database 8.4 - User Guide

Welcome to Benchmark Factory What's New in Benchmark Factory Additional Resources Overview of Benchmark Factory Benchmark Factory Components Licensing Getting Started - the Benchmark Factory Workflow Agents Create and Edit Connections Create and Edit Tests and Jobs
Jobs View Pane Job Wizards Quickstart: Create a New Job Edit a Job Industry Standard Benchmark Tests Capture and Replay a Workload Artificial Test for Desired Effect Scalability Tests Custom Tests Create/Delete Benchmark Objects Execute External File Test Options for Create Objects Test Options for Transactions Job Setup Options Use Global Search/Replace Save Job as BMF Script Copy Test to Replay, Mix, Goal, or Scalability Test
Benchmarks How Do I... Settings Test Results and Run Reports BFScripts Repository Troubleshooting The Benchmark Factory REST API Appendix About Us Adding Virtual Users System/Upgrade Requirements/Supported Databases Shortcut Keys

$BFCurrentDate

Description:

Allows you to change the date format used to populate date fields.

Parameters:

Format string-The mix of static text and variables as needed.

Variables

Definition

%a

Abbreviated weekday name

%A  

Full weekday name

%b  

Abbreviated month name

%B  

Full month name

%c  

Date and time representing appropriate locale

%d  

Day of month as decimal number (01-31)

%H  

Hour in 24-hour format (00-23)

%I  

Hour in 12 hour format (01-12)

%j   

Day of year as decimal number (001-366)

%m

Month as decimal number (01-12)

%M  

Minute as decimal number (00-59)

%p  

Current locale's A.M./P.M indicator for 12 hour clock

%S  

Second as decimal number (00-59)

%U  

Week of year as decimal number, with Sunday as first day of the week (00-53)

%w

Weekday as decimal number (0-6; Sunday is 0)

%W

Week of year as decimal number, with Monday as first day of the week (00-53)

%x  

Date representation for current locale

%X  

Time representation for current locale

%y  

Year without century, as decimal (00-99)

%Y  

Year with century, as decimal number

%z, %Z  

 

Either the time-zone name or the time zone abbreviation, depending on registry settings; no characters if time zone is unknown

%%  

Percent sign

 

Syntax:

$BFCurrentDate (Format String)

Example:

$BFCurrentDate ("%m/%d/%Y) ; returns 03/28/2005

 

$BFCurrentDateTime

Description:

Allows you to change the date/time format used to populate date fields.

Parameters:

Format string-The mix of static text and variables as needed.

Variables

Definition

%a

Abbreviated weekday name

%A  

Full weekday name

%b  

Abbreviated month name

%B  

Full month name

%c  

Date and time representing appropriate locale

%d  

Day of month as decimal number (01-31)

%H  

Hour in 24-hour format (00-23)

%I  

Hour in 12 hour format (01-12)

%j   

Day of year as decimal number (001-366)

%m

Month as decimal number (01-12)

%M  

Minute as decimal number (00-59)

%p  

Current locale's A.M./P.M indicator for 12 hour clock

%S  

Second as decimal number (00-59)

%U  

Week of year as decimal number, with Sunday as first day of the week (00-53)

%w

Weekday as decimal number (0-6; Sunday is 0)

%W

Week of year as decimal number, with Monday as first day of the week (00-53)

%x  

Date representation for current locale

%X  

Time representation for current locale

%y  

Year without century, as decimal (00-99)

%Y  

Year with century, as decimal number

%z, %Z  

 

Either the time-zone name or the time zone abbreviation, depending on registry settings; no characters if time zone is unknown

%%  

Percent sign

 

Syntax:

$BFCurrentDateTime (Format String)

Example:

$BFCurrentDateTime ("%m/%d/%Y %H:%M:%S") ; returns 03/28/2005 14:18:52

 

$BFDate

Description:

Randomly generates a date between a start date and a end date.

Parameters:

nStart-The start date.  mm/dd/yyyy

nEnd-The end date.     mm/dd/yyyy

Syntax:

$BFDate(nStart,nEnd)

Example:

$BFDate("09/14/2004","09/14/2005") ; returns "11/04/2004"

 

File Access

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating