Strategy ONE

Change Your Column Data Type

Starting in Strategy One (August 2025), you can change column data types. You can also specify a custom date, time, or datetime patterns to fit your data's needs.

Change Source Data Type Before Importing a New Table

  1. Create a Mosaic Model Using Mosaic Studio and Import Data.

  2. Before publishing the model, in the Sources view, click a table from the left pane.

  3. Click the format drop-down list under the column name.

  4. Choose a new data type.

  5. Click Add and Proceed.

    Continue building your Mosaic model.

Update Source Data Type for an Existing Table

  1. Right-click your Mosaic model and choose Edit.

  2. Click Sources.

  3. Find your table and click Edit Table .

  4. Click the format drop-down list under the column name.

  5. Choose a new data type.

  6. Click Update and Proceed.

Custom Date, Time, and Datetime Parse Patterns

For example, if your data displays as 2025-07-20 to represent July 20, 2025, enter yyyy-MM-dd. If your data displays as 07/20/2025, enter MM/dd/yyyy.

Access Custom Patterns

To access the Custom pattern dialog:

  1. Create a Mosaic Model Using Mosaic Studio and Import Data.

  2. Before publishing the model, in the Sources view, click the format drop-down list under the column name.

  3. Click Date, Time, or Datetime.

  4. Choose Custom pattern.

Values and Examples

See the following pattern options you can use:

Value Definition

y

Year; For example, yyyy for 2025 or yy for 25.

M

Month in year; For example, M for 7, MM for 07, MMM for Jul, or MMMM for July.
d Day number in month; For example, 28.

AM/PM or am/pm

AM or PM marker, to display time using a 12-hour clock.
h Hour in AM or PM, from 1 to 12.

H

Hour, based on a 24-hour clock, from 0 to 23.
m Minute; For example, 30.

s

Second; For example, 55.
fff Millisecond; For example, 978.

See the following commonly used date, time, and datetime patterns:

Type Pattern Example Description

Date

 

 

 

 yyyy-MM-dd 2025-07-20 Date (ISO)

dd-MM-yyyy

20-07-2025

Date (EU)
MM/dd/yyyy 07/20/2025 Date (US)

yyyy/MM/dd

2025/07/20

Date with slashes
yyyyMMdd 20250720 Date (compact)

MMM d, yyyy

Jul 9, 2025

Short month, single-digit day
dd MMM yyyyy 09 Jul 2025 Short month, two-digit day

Time

 

 

HH:mm

17:04:09

24-hours, colons
HH:mm.fff 17:04:09.372 With milliseconds

HH:mm:ss

17:04:09

With seconds
hh:mm AM/PM 05:04 PM 12-hour with AM/PM

hh:mm:ss AM/PM

05:04:09 PM

12-hour with AM/PM with seconds
Datetime

 

 

 yyyy-MM-dd HH:mm:ss 2025-07-20 14:23:56 Date and time (to seconds)

yyyy-MM-dd HH:mm:ss.SSS

2025-07-20 14:23:56.371

Date and time with milliseconds
MM/dd/yyyy HH:mm 07/20/2025 14:23 US style date and time

dd/MM/yyyy hh:mm AM/PM

20/07/2025 02:23 PM

Day/Month/Year with 12-hour zero-padded time and AM/PM marker
MMM dd, yyyy h:mm AM/PM Jul 20, 2025 2:23 PM Short month, day, year, non-padded hour, and minute with AM/PM