Organiza tus páginas con colecciones
Guarda y categoriza el contenido según tus preferencias.
En esta página, se explica cómo realizar transformaciones de fecha cuando preparas datos en
el espacio de trabajo de Wrangler de Cloud Data Fusion Studio.
El espacio de trabajo de Wrangler admite las transformaciones de fecha que se describen en las siguientes secciones.
Analiza las fechas
Para analizar los valores de la columna de una cadena a un tipo de datos de fecha, sigue estos pasos:
En la pestaña Datos, ve al nombre de una columna y haz clic en la flecha del expansor arrow_drop_down.
Selecciona Parse > Simple date.
Especifica el siguiente formato personalizado: MM/dd/yy HH:mm. El formato debe coincidir con el formato de fecha de la columna. Si seleccionas un formato de fecha que no coincide con las fechas de la columna, obtendrás resultados incorrectos.
El tipo de datos de la columna cambia de cadena a Timestamp_micros.
Cómo obtener componentes
En los siguientes ejemplos, se muestran directivas que recuperan componentes de fecha, como el mes, el día, el año, el minuto, el segundo o la hora:
[[["Fácil de comprender","easyToUnderstand","thumb-up"],["Resolvió mi problema","solvedMyProblem","thumb-up"],["Otro","otherUp","thumb-up"]],[["Difícil de entender","hardToUnderstand","thumb-down"],["Información o código de muestra incorrectos","incorrectInformationOrSampleCode","thumb-down"],["Faltan la información o los ejemplos que necesito","missingTheInformationSamplesINeed","thumb-down"],["Problema de traducción","translationIssue","thumb-down"],["Otro","otherDown","thumb-down"]],["Última actualización: 2025-09-04 (UTC)"],[[["\u003cp\u003eThis page details how to perform date transformations within the Wrangler workspace of Cloud Data Fusion Studio.\u003c/p\u003e\n"],["\u003cp\u003eYou can parse date values from strings into a date data type by specifying a custom format that matches the column's formatting in the Wrangler workspace.\u003c/p\u003e\n"],["\u003cp\u003eThe Wrangler workspace allows for extracting specific date components like month, year, day of the week, hour, and second, from date data types.\u003c/p\u003e\n"],["\u003cp\u003eYou can add or subtract time units, such as days, hours, minutes, months, weeks, years, seconds, or nanoseconds, to date values using specific directives.\u003c/p\u003e\n"]]],[],null,["# Transform dates\n\nThis page explains how to perform date transformations when you prepare data in\nthe Wrangler workspace of the Cloud Data Fusion Studio.\n\nThe Wrangler workspace supports the date transformations described in the\nfollowing sections.\n\nParse dates\n-----------\n\nTo parse column values from a string to a date data type, follow these steps:\n\n1. [Go to Wrangler workspace in Cloud Data Fusion](/data-fusion/docs/concepts/wrangler-overview#navigate-to-wrangler).\n2. On the **Data** tab, go to a column name and click the arrow_drop_down expander arrow.\n3. Select **Parse \\\u003e Simple date**.\n4. Specify the following custom format: `MM/dd/yy HH:mm`. The format must\n match the date formatting in the column. If you select a date format that\n doesn't match the dates in the column, you will get incorrect results.\n\n The data type of the column changes from string to\n `Timestamp_micros`.\n\nGet components\n--------------\n\nThe following examples show directives retrieving date components, such as the\nmonth, day, year, minute, second, or hour: \n\n set-column :month Transaction_date.getMonth()\n\n set-column :year Transaction_date.getYear()\n\n set-column :day_of_week Transaction_date.getDayOfWeek()\n\n set-column :day_of_month Transaction_date.getDayOfMonth()\n\n set-column :day_of_year Transaction_date.getDayOfYear()\n\n set-column :minute Transaction_date.getMinute()\n\n set-column :hour Transaction_date.getHour()\n\n set-column :second Transaction_date.getSecond()\n\n set-column :zone Transaction_date.getZone()\n\nAdd time\n--------\n\nThe following examples show directives that add units of time to the date: \n\n set-column :add_days Transaction_date.plusDays(1)\n\n set-column :add_hours Transaction_date.plusHours(200)\n\n set-column :add_minutes Transaction_date.plusMinutes(3600)\n\n set-column :add_months Transaction_date.plusMonths(3)\n\n set-column :add_weeks Transaction_date.plusWeeks(2)\n\n set-column :add_years Transaction_date.plusYears(2)\n\n set-column :add_seconds Transaction_date.plusSeconds(36000)\n\n set-column :add_nonoseconds Transaction_date.plusNanos(3600000)\n\nSubtract time\n-------------\n\nThe following examples show directives that subtract units of time from the\ndate: \n\n set-column :subtract_days Transaction_date.minusDays(1)\n\n set-column :subtract_hours Transaction_date.minusHours(200)\n\n set-column :subtract_minutes Transaction_date.minusMinutes(3600)\n\n set-column :subtract_months Transaction_date.minusMonths(3)\n\n set-column :subtract_weeks Transaction_date.minusWeeks(2)\n\n set-column :subtract_years Transaction_date.minusYears(2)\n\n set-column :subtract_seconds Transaction_date.minusSeconds(36000)\n\n set-column :subtract_nonoseconds Transaction_date.minusNanos(3600000)\n\nWhat's next\n-----------\n\n- Learn more about [Wrangler directives](/data-fusion/docs/concepts/wrangler-overview#apply_directives)."]]